Now live · Google BigQuery

Your Airtable base in your own warehouse — typed correctly.

Set it up from inside Airtable. Linked records, rollups, and multi-selects land as real, queryable columns — not stringified JSON.

Start free Read the docs →

Pro is invite-only during beta — request an invite. The free in-Airtable extension needs no invite.

✓ Read-only on Airtable✓ Two-minute setup✓ Row data never hits our servers

basebridge · sync previewtyped

Airtable fieldBigQuery column

Linked recordslinks ARRAY<STRING>

Rollup (sum)total NUMERIC

Multiple selecttags ARRAY<STRING>

Attachmentfiles ARRAY<STRUCT>

Datecreated_at TIMESTAMP

Checkboxis_active BOOL

How it works

No platform to sign up for. The whole setup happens where your base already lives.

1
Install from Airtable
Add BaseBridge from the Airtable Marketplace, right inside the base you want to sync.
2
Sign in with Google
Grant least-privilege BigQuery access with your Google account — no separate platform login.
3
Base lands in BigQuery, typed
Run the sync and your tables appear in your dataset with faithful types — linked records, rollups, and multi-selects included.

Field fidelity

Most ELT tools stringify Airtable’s harder field types into JSON blobs you have to parse in every query. BaseBridge casts them into real warehouse types instead.

Linked recordsLand as an array of linked record IDs (ARRAY<STRING>) — join back to the source table with a single UNNEST, no denormalized JSON to parse.

Rollup (sum)Aggregated rollup values land as a real NUMERIC, not the string Airtable’s API returns.

Multiple selectEvery selected option lands as an ARRAY<STRING> element, so you can filter or explode it in SQL instead of splitting a comma string.

AttachmentEach attachment keeps its filename, URL, size, and type as ARRAY<STRUCT> fields — not a flattened blob.

Security & access

BaseBridge only ever reads Airtable and only ever writes to your own warehouse.

Least-privilege Google sign-inScoped to the BigQuery access needed to load your data, nothing else.
Read-only on AirtableBaseBridge never writes back to your base.
WRITE_TRUNCATE loadsEach on-demand sync replaces the destination table cleanly, so schema changes never leave orphaned columns behind.
Row data never hits our serversThe free tier runs entirely in your browser — data moves straight from Airtable to BigQuery.

Free vs Pro

Start free. Upgrade when you need syncs to run themselves.

Free

$0 to run

Up to 2 tables
On-demand sync — you click, it runs
Runs entirely in your browser
Row data never hits our servers

Pro

For bases that need to stay current

Scheduled syncs — no manual runs
Incremental loads
Unlimited tables
More warehouses — Snowflake and Redshift, beyond BigQuery

Your base, in your warehouse, typed correctly.

Start free