Integrate with Airtable using CData connector. We utilise official CData Python (opens in a new tab) connector to ingest your data.


Feature NameSupported
Full ImportYes
Incremental ImportNo

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.