Airtable PRIVATE PREVIEW
Airtable works like a spreadsheet but gives you the power of a database to organize anything.
Features
| 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 guide
Follow our step-by-step Airtable setup guide to connect Airtable with your destination using Fivetran connectors.
Sync overview
We only support Airtable Enterprise accounts because Airtable only supports webhooks and the Metadata API for its Enterprise plan. If you are using a non-Enterprise account, you can’t set up a new Fivetran Airtable connector.
Before you create a new Airtable connector, enable webhooks for your bases using the Airtable webhook registration form to capture incremental updates from your source tables. Fivetran fetches the changes using the API and updates the data incrementally for the tables. If you don't enable webhooks for your bases, Fivetran re-imports the tables in full to your destination during every sync.
We use the Metadata API to sync all your Airtable tables to your destination using a single connector. Enable History Mode on your source tables to track historical versions of your records. You can select the tables to sync from the connector dashboard.
NOTE: 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.