NOTE: By default, Airtable users have Creator and Owner permissions for the bases that they create. We re-import the tables of the bases for which the authenticating user does not have Creator or Owner permissions. These permissions enable us to create and delete the webhooks for these bases. We can seamlessly sync the Airtable bases for which the user authenticating the connector has Creator or Owner permissions. User permissions for OAuth 2.0 authentication link If you are using API key-based authentication, we recommend that you migrate your connectors to OAuth 2.0-based authentication method.

After the deprecation period ends, API keys will no longer be able to access the Airtable API. The Airtable connector supports the OAuth 2.0 authentication mechanism.Īirtable connectors created after July 6, 2023, use only OAuth 2.0-based authentication.Īll existing Airtable connectors using API key-based authentication can now migrate to OAuth 2.0 authentication.Īirtable has announced the beginning of the deprecation period for API keys. Trigger a re-sync for all your tables under the renamed base.ĭelete the old schema from your destination. To sync your historical data and current data in a single schema, do the following: This schema does not contain the historical data. Fivetran then syncs any new data from your account to the new schema in your destination. Instead, Fivetran creates a new schema in your destination with the updated base name. NOTE: If the Airtable base name changes, the schema name is not updated in the destination by default. The destination table name will be the same as the table name in your Airtable base. 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. We add the prefix _base_name_base_id to the original schema name you choose during the connector setup. We use the Airtable base details to name the schema.

Follow our step-by-step Airtable setup guide to connect Airtable with your destination using Fivetran connectors.

Airtable api request limit