Source connector

Airtable connector

Airtable integration for databases, warehouses and BI tools

Spreadsheet-database hybrid for structured team data. Datrise captures Airtable entities such as bases, tables, records, fields, views and linked records, then lands normalized and typed models for warehouse reporting, attribution, and AI workflows.

The Airtable Web API authenticates with OAuth 2.0, personal access token, and Airtable caps calls at 5 requests per second per base, plus 50 requests per second across all bases for a given personal access token/user or service account.

Of the 6 objects, 6 sync as upserts keyed on the primary key and 0 as append-only streams, so each incremental run moves only what changed since the last watermark. Every object lands in its own table (for example `airtable_bases`) with a schema derived from the Airtable API rather than a flattened CSV, in any of the 43 supported destinations.

Datrise is in early access: pick a destination below to open the Airtable pipeline page, and join the waitlist to get the Airtable connector (CRM) with guided onboarding.

Incremental syncSchema-aware mapping43 destinations available

What Airtable data Datrise extracts

Each object lands in its own typed table. Sync mode is derived from the object: history-style objects append, everything else upserts.

Object	Landing table	Sync mode
bases	airtable_bases	Upsert by primary key, incremental on updated-at
tables	airtable_tables	Upsert by primary key, incremental on updated-at
records	airtable_records	Upsert by primary key, incremental on updated-at
fields	airtable_fields	Upsert by primary key, incremental on updated-at
views	airtable_views	Upsert by primary key, incremental on updated-at
linked records	airtable_linked_records	Upsert by primary key, incremental on updated-at

Airtable API: setup facts for the connector

Verified against the vendor documentation on 2026-09-02. Unknown values are left blank rather than guessed.

API	Airtable Web API
Authentication	OAuth 2.0, personal access token — Personal access tokens (scoped, bearer header) suit single-user integrations; OAuth 2.0 is Airtable's recommended flow for third-party apps acting on behalf of other users, and the legacy static API key was retired on February 1, 2024.
Pagination	offset — List Records returns up to `pageSize` (max 100) records plus an opaque `offset` string; pass it back as a query parameter to fetch the next page until the response omits `offset`.
Rate limit	5 requests per second per base, plus 50 requests per second across all bases for a given personal access token/user or service account
Incremental cursor	Not published
Webhooks	Yes — Webhooks API
Bulk export	No
Deletes detectable	Yes — A base webhook's payload lists `destroyedRecordIds` per table, but only while the webhook and its payload backlog are alive.

Official API reference

What bites when replicating Airtable

List Records caps pages at 100 rows via `pageSize`/`offset` and has no implicit modified-time field, so a connector needs a base-side `Last Modified Time` formula field before it can do anything but full refreshes.
The per-base limit is 5 requests/second; exceeding it returns HTTP 429 and Airtable requires a 30-second back-off before retrying, which throttles any two connectors polling the same base at once.
Webhooks are a ping-only notification (base ID, webhook ID, timestamp); the actual `destroyedRecordIds`/`changedRecordsById` diff has to be pulled separately from List Webhook Payloads, and both the webhook (7 days idle) and its stored payloads (7 days total) expire, so a poller that skips a week permanently loses delete visibility.
Record-mutation endpoints (create/update/delete) accept at most 10 records per call, so any upsert-based sync-back needs its own batching loop rather than sending one large array.

Compare this against every other documented API

Popular destinations for Airtable

Choose a destination below to open the ready pipeline page.

A
Airtable
Relational spreadsheet destination for ops and go-to-market teams.
View pipeline
A
Amazon Athena
Serverless SQL over S3 data lake tables.
View pipeline
A
Amazon DynamoDB
Serverless key-value and document store on AWS.
View pipeline
A
Amazon QuickSight
AWS serverless BI with SPICE and embedded analytics.
View pipeline
A
Amazon Redshift
AWS petabyte-scale warehouse with Spectrum.
View pipeline
A
Amazon S3 Data Lake
Object storage landing zone for parquet and snapshots.
View pipeline
A
Apache Superset
Open-source BI for SQL exploration, charts, and dashboard publishing.
View pipeline
A
Azure Data Lake Storage
ADLS Gen2 object storage for analytics workloads.
View pipeline
A
Azure Synapse
Microsoft analytics workspace with SQL pools.
View pipeline

Airtable connector FAQ

What Airtable data does the connector extract?: 6 objects: bases, tables, records, fields, views and linked records. Each lands in its own table with types preserved; history-style objects (0) load as append-only streams.
Is the Airtable integration incremental?: Yes. After the initial full load, every run reads only records changed since the last watermark (updated-at or event timestamp) and applies an upsert or an append depending on the object.
Where can I load Airtable data?: Into 43 destinations: relational databases, cloud warehouses, data lakes, spreadsheets and BI tools. Each Airtable → destination pair has its own page with the object-to-table mapping.

Related CRM sources

Other sources in the same category, each with its own connector page.

Early access

Launch your Airtable pipeline with guided onboarding

Join the waitlist to get priority access for Airtable integrations with guided setup, schema-aware mapping, and production-grade incremental sync.