Skip to main content


The BigQuery Data Pool lets you synchronize a BigQuery table or view to Propel, providing an easy way to power your analytic dashboards, reports, and workflows with a low-latency data API on top of BigQuery.

Consider using Propel on top of BigQuery when:

  • You require sub-second query performance for dashboards or reports.
  • You need to support high-concurrency and high-availability data workloads, such as customer-facing or mission-critical applications.
  • You require fast data access through an API for web and mobile apps.
  • You are building B2B SaaS or consumer applications that require multi-tenant access controls.

Get started

Set up guide

Follow our step-by-step BigQuery setup guide to connect your BigQuery data warehouse with Propel.

Architecture overview

The BigQuery Data Source lets you use any table to power your Data Pools. Propel connects to the specified GCP project ID and BigQuery dataset using the provided service account. When you create a Data Pool from a BigQuery table or view, Propel automatically synchronizes the data from your BigQuery table into your Data Pool.

The architectural overview when connecting BigQuery to Propel.


BigQuery Data Pools support the following features:

Feature nameSupportedNotes
Syncs insertsPropel incrementally syncs new records from the BigQuery table and appends them to Propel. Ideal for immutable event data.
Syncs updates and deletesUpdates and deletes are not supported during preview.
Re-syncReSyncs are not supported during preview.
Configurable sync intervalYou can configure syncs to occur at intervals ranging from every minute to every 24 hours.
Sync Pausing / Resuming
Delete Job APISee Delete Job API.
API configurable⚠️Only BigQuery Data Pools, not BigQuery Data Sources. See API reference docs.
Terraform configurable⚠️Only BigQuery Data Pools, not BigQuery Data Sources. See Propel Terraform docs.

Supported data structures

Below are the BigQuery data structures that Propel supports.

TablesIncludes regular, temporary, or object tables.
ViewIncludes regular and materialized views.

Note: The BigQuery Data Source does not support the following data structures:

  • Tables exported from Google Analytics
  • Partitioned tables
  • Clustered tables
  • Tables stored in a cloud storage service or Google Drive

Frequently asked questions

Does Propel read through to BigQuery on every query?

No, Propel only queries BigQuery to sync records, not to serve requests via the API.