Writing SQL in Runway

​

Identifying a Fivetran integration

1. During setup – The integration will display the Fivetran label when being installed.
2. After installation – If already installed, you can check by looking at the URL in the query editor.

​

Adding a new query

For integrations that support SQL queries, you can click + next to integration name in the sidebar to create a new query.

You can then change the default query name, New query, to something more descriptive. To do this, click the three-dots button next to the query name in the sidebar and select Rename query.

​

Writing SQL for data warehouses

• Google BigQuery – Uses GoogleSQL
• Snowflake – Supports standard SQL
• Amazon Redshift – Uses PostgreSQL

You can manually refresh data at any time by going into the query and selecting Run query.

​

Writing SQL for data Fivetran integrations

SHOW TABLES

1. Data is pulled from your source system into Runway’s Snowflake data warehouse every morning (US Pacific Time).
2. Runway then automatically executes integration queries shortly after to refresh the data in your model.

1. Manually trigger a sync from your source system.
2. Once the source data is refreshed, rerun your SQL queries manually to update your model. This step ensures the newly synced data appears in your model.

​

Best practices & tips

• Structure your queries to return a long dataset—a list of transactions, accounts, or metrics with a daily or monthly amount. This format ensures flexibility for modeling. Example:

  dimension_1	dimension_..x	date_1	date_..x	value_1	value_..x
  Account 1	Asset	01/01/2025	03/01/2025	10	20
  Account 2	Liability	01/02/2025	04/01/2025	30	40

• Include as all dimensions, dates, or values needed—not all of them need to be used in the final database configuration.
• Aggregate/roll up data to the minimum level required for modeling and drill-downs. For example, if pulling general ledger data, and only monthly spend per account is needed, write your query to pre-aggregate the data:
  • Avoid this
    Copy

    Ask AI

    select
    	account,
    	transaction_amount,
    	transaction_date
    from general ledger
    
    

  • Do this
    Copy

    Ask AI

    select
    	account,
    	sum(transaction_amount) as transaction_amount,
    	date_trunc('month',transaction_date) transaction_month
    from general ledger
    group by 1,3
    
    

• Filter out unwanted data—some Fivetran tables contain columns like _fivetran_deleted. Filtering out these records helps prevent duplicates records in your dataset.