Linking Airtable as a source

Alpha release

This source is currently in alpha. The interface and available tables may change.

The Airtable connector pulls your Airtable data — bases, tables, and records — into the PostHog data warehouse.

Adding a data source

Go to the sources tab of the data pipeline section in PostHog.
Click + New source and then click Link next to Airtable.
You need a personal access token from Airtable. Create one from airtable.com/create/tokens. Grant the data.records:read and schema.bases:read scopes so all tables can sync, and grant access to the bases you want to sync. Copy the token value.
Back in PostHog, paste the token in the Personal access token field and click Next.
Select the tables you want to sync, set the sync method and frequency, then click Import.

Once the syncs are complete, you can start using Airtable data in PostHog.

Table	Description	Sync method
`bases`	Metadata listing of Airtable bases your token can access	Full refresh
`tables`	Schema information for tables within each base	Full refresh
`records`	Data rows from all tables across all accessible bases	Incremental

Incremental tables sync only new records on each run. Full refresh tables reload all data on each sync.

Incremental sync for records is append-only using the createdTime field. Updates to existing records are not detected — use a full refresh to catch those.
Records expose no last-modified field, so there is no way to incrementally sync updates.
Each record row carries _base_id and _table_id fields to identify its source base and table.
Record IDs are only unique within a table, so records use the composite primary key (_base_id, _table_id, id).

Option	Type	Required
`Personal access token`	password	Yes