Your base, in your warehouse — every mechanism, in the open.
BaseBridge is a native Airtable extension that syncs a base into your own BigQuery warehouse, read-only on Airtable, with the writes going only to your project. This page is the long version of how it casts types, what access it asks for, and what’s different between Free and Pro.
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, so a query against the synced table looks the way you’d expect it to.
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.
DateLands as a real TIMESTAMP, sortable and comparable in SQL instead of a formatted string.
CheckboxLands as a native BOOL, so it filters with WHEREthe way you’d expect.
Security & access
BaseBridge only ever reads Airtable and only ever writes to your own warehouse. Row data is never sent to, or stored on, our servers.
- Least-privilege Google sign-inSign-in requests only the bigquery scope needed to load your data — nothing broader.
- Read-only on AirtableBaseBridge never writes back to your base, and never modifies your schema or records.
- 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 the Airtable API to the BigQuery API over your own authenticated connection.
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
$19/mo · free during beta
- Everything in Free, plus:
- Scheduled syncs — no manual runs
- Incremental loads
- Unlimited tables
- More warehouses — Snowflake and Redshift, beyond BigQuery