Docs
Quickstart · warehouses · field-typing reference
BaseBridge is an Airtable extension, installed from inside the base you want to sync. There is no separate platform to sign up for — setup, sync, and configuration all happen where your base already lives.
Quickstart
Two minutes, start to first synced table.
- 1
Install the extension
From the Airtable Marketplace, inside the base you want to sync.
- 2
Sign in with Google
Grants the single bigquery scope, nothing broader — no separate BaseBridge account.
- 3
Pick tables and a destination
Choose up to 2 tables on Free, and the BigQuery dataset to land them in.
- 4
Run the sync
Each run is a WRITE_TRUNCATE load — the destination table is replaced cleanly, so schema changes never leave orphaned columns behind.
Free vs Pro. The steps above are the Free tier, run entirely in your browser: on-demand, up to 2 tables. Pro adds scheduled syncs, incremental loads, unlimited tables, and more warehouses — see Product.
Warehouses
BigQuery is live today; Snowflake and Redshift are next, on Pro.
| Warehouse | Status |
|---|---|
| Google BigQuery | Live — Free and Pro |
| Snowflake | Pro, coming next |
| Redshift | Pro, coming next |
Field-typing reference
Airtable’s API returns most field values as loosely-typed JSON. BaseBridge maps each declared field type to a concrete warehouse column type on load.
| Airtable field | BigQuery column | Notes |
|---|---|---|
| Single line / long / rich text, email, URL, phone, single select | STRING | Declared 1:1. |
| Number, currency, percent, duration | FLOAT64 | Airtable numbers are IEEE doubles, so these land as FLOAT64, not NUMERIC. |
| Rating, auto number, count | INT64 | Declared 1:1. |
| Checkbox | BOOL | Declared 1:1. |
| Date | TIMESTAMP | Also applies to created time / last modified time. |
| Linked records | ARRAY<STRING> | Array of linked record IDs — UNNEST to join back to the source table. |
| Multiple select | ARRAY<STRING> | One array element per selected option. |
| Rollup (sum) | NUMERIC | Cast from Airtable’s API string to a real numeric column. |
| Attachment | ARRAY<STRUCT> | Filename, URL, size, and type kept as struct fields per attachment. |
Every synced table also gets a stable _airtable_record_id key column, so re-syncs and future joins have a durable primary key even though Free runs a full replace each time.