Skip to main content
Log inGet a demo

Sync data from BigQuery to Airtable

Connect your data from BigQuery to Airtable with Hightouch. No APIs, no months-long implementations, and no CSV files. Just your data synced forever.

Get started

The world’s most innovative companies choose Hightouch as their Composable CDP

Spotify.
Warner Music Group.
PetSmart.
WeightWatchers.
Ramp.
Calendly.
GitLab.
Grammarly.
Spotify.
Aritzia.
Warner Music Group.
PetSmart.
Tripadvisor.
GameStop.
Cars.com.
WeightWatchers.
Iterable.
Ramp.
Plaid.
Calendly.
GitLab.
Malwarebytes.
Greenhouse.
Grammarly.

Activate your data in 3 easy steps

An illustration showing logos of various sources connecting to destination logos.

Use cases

Sync data from BigQuery to Airtable

  • Sync all of the results of a SQL query into an airtable base so that the data is available to business teams
  • Run ops and fulfill orders using Airtable as the ops layer, save time on building product
  • Update records that already exist in your Airtable using information from your database/warehouse
Hightouch Audiences user interface.

What methods can I use to model my BigQuery data?

  • Semi-opaque, open dropdown with three example dbt model names such as 'dbt.model.name.1'.

    dbt model selector

    Sync directly with your dbt models saved in a git repository.

  • Semi-opaque open dropdown with three example Look names such as 'Look 1'.

    Looker

    Query using Looks. Hightouch turns your look into SQL and will pull from your source.

  • SQL editor.

    SQL editor

    Create and Edit SQL from your browser. Hightouch supports SQL native to BigQuery.

  • Semi-opaque open dropdown with three example workbook names such as 'Workbook 1'.

    Sigma model

    Hightouch converts your Sigma workbook element into a SQL query that runs directly on BigQuery.

  • Semi-opaque open dropdown with three example table names such as 'schema.table.name.1'.

    Table selector

    Select available tables and sheets from BigQuery and sync using existing views without having to write SQL.

  • Visual query builder reading 'All rows that...' with a button labeled 'select a property'.

    Customer Studio

    For less technical users, pass traits and audiences from BigQuery using our visual segmentation builder.

FAQs

Other BigQuery integrations

BigQuery to Acoustic

Other Airtable integrations