Airtable
Overview
Integrate with Airtable using CData connector. We utilise official CData Python (opens in a new tab) connector to ingest your data.
Features
| Feature Name | Supported |
|---|---|
| Full Import | Yes |
| Incremental Import | No |
Supported streams
We support data extraction from all tables and views (opens in a new tab) listed in the official CData documentation.
Getting started
Requirements and prerequisites
Airtable account.
Set up guide
Create a source
Create a new source and enter a Name for it and select "Airtable (CData)" from a connector type list, then click Create.
Configure a secret
Create a new secret (or reuse an existing one). Authenticate using OAuth or by supplying your Personal Access Token.
Define settings
- Base Id (Optional) - Id of the base. This property is not required when the Metadata API is enabled, but specifying it restricts the metadata that will be retrieved.
- Enable Metadata API (Optional) - Enabling the Metadata API gives you read-only access to a list of your bases, tables and fields, and changes the behaviour of the driver for all operations and queries.
- Display Object Ids (Optional) - Boolean determining if schema, table, view and column names should be replaced by their corresponding internal ID.
- Use Simple Names (Optional) - Boolean determining if simple names should be used for tables and columns.