Airtable link
Airtable is an online collaboration platform for creating and sharing relational databases.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | |
Custom data | check | |
Data blocking | check | Column Level |
Column hashing | check | |
Re-sync | check | |
History | check | Supports history mode. |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
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.
NOTE: If the Airtable base name changes, the schema name is not updated in the destination by default. Instead, Fivetran creates a new schema in your destination with the updated base name. Fivetran then syncs any new data from your account to the new schema in your destination. This schema does not contain the historical data.
To sync your historical data and current data in a single schema, do the following:
Trigger a re-sync for all your tables under the renamed base.
Delete the old schema from your destination.
Authenticationlink
The Airtable connector supports the OAuth 2.0 authentication mechanism.
User permissions for OAuth 2.0 authenticationlink
We can seamlessly sync the Airtable bases for which the user authenticating the connector has Creator or Owner permissions. These permissions enable us to create and delete the webhooks for these bases.
We re-import the tables of the bases for which the authenticating user does not have Creator or Owner permissions.
NOTE: By default, Airtable users have Creator and Owner permissions for the bases that they create. If the bases are from a shared workspace, the owner of the shared workspace can grant the necessary permissions to the collaborators.
Limitationslink
Listed limitations are from the source side.
OAuth 2.0 authenticationlink
For each third-party integration, Airtable limits the maximum number of authorizations to 20 for a single user. Because of this limitation, a single Airtable user can create a maximum of 20 Airtable connectors using OAuth-based authentication. For more information about this limitation, see Airtable's documentation.
Payloadslink
In Airtable's server, Airtable stores its incremental data as payload objects. Airtable deletes these payloads from its server after 7 days of generating them, regardless of whether our connector has synced these changes. For more information, see Airtable's documentation.
If you pause the connector or if the syncs fail continuously for more than 7 days, the payloads may not be available in Airtable's server to perform an incremental sync. To avoid data integrity issues in such scenarios, if Airtable deletes your payloads from its server, we re-import all the selected tables of the associated base. These re-imports count towards paid MAR.
Webhookslink
Airtable allows a maximum of 10 webhooks for each base. If we are unable to create a webhook due to this limitation, we re-import the tables of the base until we can create a webhook. These re-imports contribute towards your MAR. See our troubleshooting documentation to learn how to delete existing webhooks in Airtable.
Webhooks created using OAuth authentication have an expiration time of 7 days.
Fivetran will refresh the OAuth-based webhooks associated with the connector during the sync of any table under the base which the webhook is associated with.
If a OAuth webhook expires, it becomes disabled, so a new OAuth webhook is created and all tables in the base are re-imported, which is counted towards paid MAR.
Sync noteslink
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.
Airtable attachment URLs shared using the API automatically expire after a couple of hours. You can use an external storage service such as Dropbox or Google Drive to store the attachments and link the URLs.