Data warehouses

Runway integrates with a variety of data warehouse providers, allowing you to pull data that has already been processed, transformed, or sourced from systems that Runway does not integrate with directly.

Supported data warehouses

We strongly support the following providers:

• Snowflake → Setup guide
• Google BigQuery → Setup guide
• Amazon Redshift → Setup guide

Setup guides are linked directly in Runway, but they are also available here for reference.

How Runway connects to your data warehouse

Runway has an in-app SQL editor that allows us to query your data warehouse directly. To set up the connection:

1. Create a user for Runway in your data warehouse.
2. Add our provider’s IP addresses to your allowlist (found here).

Runway leverages the US data center.

Data warehouses FAQs

How do I write SQL in Runway?

See our help doc.

What other databases can Runway pull from?

We also support SQL databases (via Fivetran) for:

• PostgreSQL
• MySQL
• SQL Server (including Azure, Google, and AWS-hosted instances)

Is there a row limit on data queries?

Yes, each query must return fewer than 50,000 rows.

How can I work around the row limit?

If your dataset exceeds 50,000 rows, consider the following solutions:

• Aggregate data in SQL → Use SUM, GROUP BY, or similar functions to reduce the row count.
• Limit the data scope → Restrict queries by time range or other relevant filters.
• Split large datasets → Break data into multiple queries or databases (e.g., by product line or geography).