Airtable
Set up the Airtable source connector and find its reference information on this page.
Prerequisites
- An active Airtable account
- Personal Access Token with these scopes:
data.records:readdata.recordComments:readschema.bases:read
Setup guide
Step 1: Set up Airtable
For Airbyte Open Source:
-
Go to https://airtable.com/create/tokens to create a new token.

-
Add these scopes:
data.records:readdata.recordComments:readschema.bases:read

-
Select the required bases, or allow access to all available bases. Then press the
Create Tokenbutton.
-
Save the token from the popup window.
Step 2: Set up the Airtable connector in Airbyte
For Airbyte Cloud:
-
Sign in to your Log into your Airbyte Cloud account.
-
Click Sources, then click + New source.
-
On the Set up the source page, select Airtable from the Source type dropdown.
-
Enter a name for the Airtable connector.
-
You can authenticate your Airtable account with OAuth or a Personal Access Token. OAuth is recommended for Airbyte Cloud.
- To authenticate with OAuth, select OAuth2.0 from the Authentication dropdown. Click Authenticate your Airtable account to sign in with Airtable. Select the required workspaces to sync, then authorise your account.
- To authenticate with a Personal Access Token, select Personal Access Token from the Authentication dropdown. Enter the Access Token for your Airtable account.
:::info
OAuth may return a
400or401error and cause the sync to fail. If this happens, re-authenticate your Airtable connector. Click Authenticate your Airtable account again in the connector settings. :::
-
Click Set up source.
For Airbyte Open Source:
- Open the Airbyte Open Source dashboard.
- In the left navigation bar, click Sources. In the top-right corner, click +new source.
- On the Set up the source page, enter a name for the Airtable connector. Select Airtable from the Source type dropdown.
- Select Personal Access Token from the Authentication dropdown. Enter the Access Token for your Airtable account.
- Click Set up source.
Configuration options
You can use these optional Airtable connector settings:
- Number of Concurrent Threads: Controls how many concurrent threads the connector uses for syncing. The default is 5, the minimum is 2 and the maximum is 40. Higher values can improve performance when syncing multiple bases or during I/O wait time. The connector automatically respects Airtable’s limit of 5 requests per second per base. Increasing this value won’t cause rate limit errors.
- Add Base ID to Stream Name: Includes the Airtable base ID in stream names when enabled, ensuring each name is unique. This helps when cloned Airtable bases contain tables with the same name. Enabling this option changes stream names and requires a full data refresh.
Renamed and deleted tables
If you rename a table after syncing starts, the connector stops syncing it. Reset your connection schema, then select the table again. The table then syncs to the destination under its new name. This happens because Airtable can’t tell Airbyte which tables were renamed. If you delete a previously synced table, the connector stops syncing it.
Supported sync modes
The Airtable source connector supports these sync modes:
- Full Refresh - Overwrite
- Full Refresh - Append
- Incremental - Append
- Incremental - Append + Deduped (select a primary key such as
_airtable_id; Airtable doesn’t provide a source-defined primary key)
Incremental sync compares Airtable’s LAST_MODIFIED_TIME() with the cursor. It falls back to CREATED_TIME() when Airtable leaves last-modified blank for records that have never been edited. It doesn’t detect changes made only to computed fields: formula, rollup, lookup and count. Deleted records aren’t captured. A 15-minute lookback re-reads recent records. _airtable_extracted_at is the cursor and contains the sync window’s end time.
Supported streams
This source uses the Metadata API to sync every table from your Airtable bases. After renaming or adding a column, refresh the source schema in Airbyte to update the catalog.
Base collaborators
The base_collaborators stream lists people added directly to each base, with one record for each person and base. Each record includes base_id, base_name, userId, email, permissionLevel, createdTime and grantedByUserId. It reads Airtable’s Get base collaborators endpoint using the connector’s existing schema.bases:read scope. It doesn’t include groups or workspace members who weren’t added directly to the base. Records contain collaborator email addresses.
Performance limits
Airtable enforces these rate limits:
- 5 requests per second per base
- 50 requests per second across all requests from a given user or service account
If either limit is exceeded, the API returns a 429 status code. Requests must then wait 30 seconds before retrying. The connector handles this automatically with built-in backoff and retry logic.
Data type map
| Integration Type | Airbyte Type | Nullable |
|---|---|---|
multipleAttachments | string | Yes |
autoNumber | number | Yes |
barcode | string | Yes |
button | string | Yes |
checkbox | boolean | Yes |
singleCollaborator | string | Yes |
count | number | Yes |
createdBy | string | Yes |
aiText | string | Yes |
createdTime | datetime or date | Yes |
currency | number | Yes |
email | string | Yes |
date | string, format: date | Yes |
duration | number | Yes |
lastModifiedBy | string | Yes |
dateTime | datetime, format: date-time | Yes |
lastModifiedTime | datetime, date, or string | Yes |
multipleRecordLinks | array with strings | Yes |
multilineText | string | Yes |
multipleCollaborators | array with strings | Yes |
multipleSelects | array with strings | Yes |
number | number | Yes |
percent | number | Yes |
phoneNumber | string | Yes |
rating | number | Yes |
richText | string | Yes |
singleLineText | string | Yes |
singleSelect | string | Yes |
simpleText | string | Yes |
manualSort | string | Yes |
externalSyncSource | string | Yes |
url | string | Yes |
formula | string, number, or array | Yes |
lookup | array (typed by result field) | Yes |
multipleLookupValues | array (typed by result field) | Yes |
rollup | array (typed by result field) | Yes |
- All fields are nullable, so any field value can be empty.
createdTimeandlastModifiedTimeemitdatetimeordate, based on the field’s display configuration in Airtable. IflastModifiedTimehas no configured result type, it emitsstring.formulaemitsnumberfor numeric result types: number, currency, percent or duration. It emitsarrayfor array-producing formulas: ARRAYCOMPACT, ARRAYFLATTEN, ARRAYUNIQUE and ARRAYSLICE. Otherwise, it emitsstring.lookup,multipleLookupValuesandrollupemit typed arrays matching the referenced field’s type. For example, numeric fields produce number arrays, while text fields produce string arrays.
IP allow list
If you use Airbyte Cloud with access restricted to specific IPs, add the Airbyte Cloud IP addresses to your allow list.
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 4.8.1 | 2026-11-10 | 89120 | Update dependencies |
| 4.8.0 | 2026-11-04 | 90312 | Add base_collaborators stream |
| 4.7.0 | 2026-10-15 | 89000 | Add incremental sync support for table streams |
| 4.6.43 | 2026-10-13 | 88520 | Update dependencies |
| 4.6.42 | 2026-10-06 | 87744 | Update dependencies |
| 4.6.41 | 2026-09-29 | 87090 | Update dependencies |
| 4.6.40 | 2026-09-22 | 86538 | Update dependencies |
| 4.6.39 | 2026-09-15 | 85936 | Update dependencies |
| 4.6.38 | 2026-09-08 | 85385 | Update dependencies |
| 4.6.37 | 2026-08-18 | 84475 | Update dependencies |
| 4.6.36 | 2026-08-11 | 83837 | Update dependencies |
| 4.6.35 | 2026-08-04 | 83351 | Update dependencies |
| 4.6.34 | 2026-07-28 | 82799 | Update dependencies |
| 4.6.33 | 2026-07-21 | 82303 | Update dependencies |
| 4.6.32 | 2026-07-14 | 81711 | Update dependencies |
| 4.6.31 | 2026-07-07 | 80955 | Update dependencies |
| 4.6.30 | 2026-06-24 | 80771 | Upgrade CDK to 7.23.3 |
| 4.6.29 | 2026-06-23 | 80374 | Update dependencies |
| 4.6.28 | 2026-06-16 | 79749 | Update dependencies |
| 4.6.27 | 2026-06-09 | 79201 | Update dependencies |
| 4.6.26 | 2026-06-02 | 76518 | Update dependencies |
| 4.6.25 | 2026-04-13 | 76276 | Rename “concurrent workers” to “concurrent threads” in connector spec |
| 4.6.24 | 2026-03-10 | 74540 | Update dependencies |
| 4.6.23 | 2026-02-24 | 73755 | Update dependencies |
| 4.6.22 | 2026-02-17 | 73390 | Update dependencies |
| 4.6.21 | 2026-02-10 | 72993 | Update dependencies |
| 4.6.20 | 2026-02-03 | 72632 | Update dependencies |
| 4.6.19 | 2026-01-20 | 71999 | Update dependencies |
| 4.6.18 | 2026-01-14 | 71506 | Update dependencies |
| 4.6.17 | 2026-01-08 | 70856 | Add configurable option to include base_id in stream names for uniqueness |
| 4.6.16 | 2026-01-08 | 71229 | Promoting release candidate 4.6.16-rc.1 to a main version. |
| 4.6.16-rc.1 | 2025-12-10 | 69778 | Add HTTPAPIBudget and concurrency_level for improved sync performance |
| 4.6.15 | 2025-12-02 | 70296 | Bump memory for discover to 3GB and check to 1.5GB |
| 4.6.14 | 2025-11-25 | 69916 | Update dependencies |
| 4.6.13 | 2025-10-29 | 69029 | Update dependencies |
| 4.6.12 | 2025-10-14 | 65633 | Update dependencies |
| 4.6.11 | 2025-09-09 | 65991 | Update to CDK v7.0.0 |
| 4.6.10 | 2025-08-23 | 65352 | Update dependencies |
| 4.6.9 | 2025-08-09 | 64651 | Update dependencies |
| 4.6.8 | 2025-08-02 | 64436 | Update dependencies |
| 4.6.7 | 2025-07-21 | 63281 | Bump default Memory on DISCOVER to 2.5GB |
| 4.6.6 | 2025-07-15 | 63309 | Adds type property to config_normalization_rules in manifest |
| 4.6.5 | 2025-07-12 | 43886 | Update dependencies |
| 4.6.4 | 2025-07-10 | 62894 | Bump default Memory on DISCOVER to 2GB |
| 4.6.3 | 2025-07-03 | 62118 | Bump default Memory on DISCOVER to 1.5 GB |
| 4.6.2 | 2025-06-17 | 61643 | Bump default Memory on DISCOVER to 1GB |
| 4.6.1 | 2025-06-05 | 61394 | Fix schema issue related to migration |
| 4.6.0 | 2025-06-04 | 60875 | Migrate to manifest-only |
| 4.5.1 | 2025-02-13 | 53672 | Add type for aiText and lastModifiedTime, when result type is null |
| 4.5.0 | 2025-02-12 | 53657 | Promoting release candidate 4.5.0-rc.4 to a main version. |
| 4.5.0-rc.4 | 2025-02-04 | 53156 | Add default type for rollup, lookuo and multiplelookup, add new type manualSort |
| 4.5.0-rc.3 | 2025-01-29 | 52624 | Fix type for multipleLookupValues fields |
| 4.5.0-rc.2 | 2025-01-28 | 52595 | Fix type for datetime fields |
| 4.5.0-rc.1 | 2025-01-27 | 49813 | Update to low-code |
| 4.4.0 | 2024-07-16 | 41160 | Update CDK version to v3.5.2 |
| 4.3.1 | 2024-07-16 | 41536 | Update dependencies |
| 4.3.0 | 2024-07-16 | 41072 | Update CDK version to v2.4.0 |
| 4.2.6 | 2024-07-09 | 41080 | Update dependencies |
| 4.2.5 | 2024-07-06 | 40789 | Update dependencies |
| 4.2.4 | 2024-06-25 | 40290 | Update dependencies |
| 4.2.3 | 2024-06-22 | 40085 | Update dependencies |
| 4.2.2 | 2024-06-04 | 39089 | [autopull] Upgrade base image to v1.2.1 |
| 4.2.1 | 2024-05-29 | 38765 | Fix next_page_token() to correctly adhere to HttpStream interface |
| 4.2.0 | 2024-03-19 | 36267 | Pin airbyte-cdk version to ^0 |
| 4.1.6 | 2024-02-12 | 35149 | Manage dependencies with Poetry. |
| 4.1.5 | 2023-10-19 | 31599 | Base image migration: remove Dockerfile and use the python-connector-base image |
| 4.1.4 | 2023-10-19 | 31360 | Update docstings |
| 4.1.3 | 2023-10-13 | 31360 | Update error message for invalid permissions |
| 4.1.2 | 2023-10-10 | 31215 | Exclude bases without permission |
| 4.1.1 | 2023-10-10 | 31119 | Add user-friendly error message when refresh token has expired |
| 4.1.0 | 2023-10-10 | 31044 | Add source table name to output records |
| 4.0.0 | 2023-10-09 | 31181 | Additional schema processing for the FORMULA schema type: Convert to simple data types |
| 3.0.1 | 2023-05-10 | 25946 | Skip stream if it does not appear in catalog |
| 3.0.0 | 2023-03-20 | 22704 | Fix for stream name uniqueness |
| 2.0.4 | 2023-03-15 | 24093 | Update spec and doc |
| 2.0.3 | 2023-02-02 | 22311 | Fix for singleSelect types when discovering the schema |
| 2.0.2 | 2023-02-01 | 22245 | Fix for empty result object when discovering the schema |
| 2.0.1 | 2023-02-01 | 22224 | Fixed broken API Key authentication |
| 2.0.0 | 2023-01-27 | 21962 | Added casting of native Airtable data types to JsonSchema types |
| 1.0.2 | 2023-01-25 | 20934 | Added OAuth2.0 authentication support |
| 1.0.1 | 2023-01-10 | 21215 | Fix field names |
| 1.0.0 | 2022-12-22 | 20846 | Migrated to Metadata API for dynamic schema generation |
| 0.1.3 | 2022-10-26 | 18491 | Improve schema discovery logic |
| 0.1.2 | 2022-04-30 | 12500 | Improve input configuration copy |
| 0.1.1 | 2021-12-06 | 8425 | Update title, description fields in spec |