Airtable is an online collaboration platform for creating and sharing relational databases.
|Data blocking||check||Column Level|
|Fivetran data models|
Follow our step-by-step Airtable setup guide to connect Airtable with your destination using Fivetran connectors.
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
id is the 16-digit base ID.
The destination table name will be the same as the table name in your Airtable base.
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.