Airtable is an online collaboration platform for creating and sharing relational databases.
Featureslink
| Feature Name | Supported |
|---|---|
| Capture Deletes | check |
| Custom Data | check |
| Data Blocking | |
| Column Hashing | |
| Re-sync | check |
| History | |
| API Configurable | check |
| Priority-first sync | |
| dbt Package |
Setup guidelink
Follow our step-by-step Airtable setup guide to connect Airtable with your destination using Fivetran connectors.
Schema informationlink
We use the Airtable base details to name the schema. We add the prefix _base_name_base_id to the original schema name you choose during the connector setup. For example, if you entered airtable as the destination schema name in the setup form, and the name of your Airtable base is marketing, your schema name will be airtable_marketing_id, where id is the 16-digit base ID.
The destination table name will be the same as the table name in your Airtable base.
Sync notelink
If you enable history mode for a table but later deselect the table from the Schema tab, then the historical data for the table will be lost because Fivetran re-imports the complete table when you reselect the table for the sync.
In some instances, Airtable generates an event for a single character change in a column, resulting in multiple updates to the same record in your destination. To work around this source mechanism and avoid phantom updates while using History Mode, Fivetran assigns the record timestamp value with minute-level granularity as the _fivetran_start value. For example, if the record timestamp value is 2021-06-23T15:19:12.610Z, we assign _fivetran_start to be 2021-06-23T15:19:00.000Z. This results in a single record update at any given minute in your destination.