Advanced Analytica Advanced Analytica: IBOM
← All connectors
Airtable logo

Source connector

Airtable

Set up Airtable as a source and move its data into your chosen destination.

Version 4.8.1 certified generally available

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:read
    • data.recordComments:read
    • schema.bases:read

Setup guide

Step 1: Set up Airtable

For Airbyte Open Source:

  1. Go to https://airtable.com/create/tokens to create a new token. Generate new Token

  2. Add these scopes:

    • data.records:read
    • data.recordComments:read
    • schema.bases:read

    Add Scopes

  3. Select the required bases, or allow access to all available bases. Then press the Create Token button. Add Bases

  4. Save the token from the popup window.

Step 2: Set up the Airtable connector in Airbyte

For Airbyte Cloud:

  1. Sign in to your Log into your Airbyte Cloud account.

  2. Click Sources, then click + New source.

  3. On the Set up the source page, select Airtable from the Source type dropdown.

  4. Enter a name for the Airtable connector.

  5. 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 400 or 401 error and cause the sync to fail. If this happens, re-authenticate your Airtable connector. Click Authenticate your Airtable account again in the connector settings. :::
  6. Click Set up source.

For Airbyte Open Source:

  1. Open the Airbyte Open Source dashboard.
  2. In the left navigation bar, click Sources. In the top-right corner, click +new source.
  3. On the Set up the source page, enter a name for the Airtable connector. Select Airtable from the Source type dropdown.
  4. Select Personal Access Token from the Authentication dropdown. Enter the Access Token for your Airtable account.
  5. 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:

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 TypeAirbyte TypeNullable
multipleAttachmentsstringYes
autoNumbernumberYes
barcodestringYes
buttonstringYes
checkboxbooleanYes
singleCollaboratorstringYes
countnumberYes
createdBystringYes
aiTextstringYes
createdTimedatetime or dateYes
currencynumberYes
emailstringYes
datestring, format: dateYes
durationnumberYes
lastModifiedBystringYes
dateTimedatetime, format: date-timeYes
lastModifiedTimedatetime, date, or stringYes
multipleRecordLinksarray with stringsYes
multilineTextstringYes
multipleCollaboratorsarray with stringsYes
multipleSelectsarray with stringsYes
numbernumberYes
percentnumberYes
phoneNumberstringYes
ratingnumberYes
richTextstringYes
singleLineTextstringYes
singleSelectstringYes
simpleTextstringYes
manualSortstringYes
externalSyncSourcestringYes
urlstringYes
formulastring, number, or arrayYes
lookuparray (typed by result field)Yes
multipleLookupValuesarray (typed by result field)Yes
rolluparray (typed by result field)Yes
  • All fields are nullable, so any field value can be empty.
  • createdTime and lastModifiedTime emit datetime or date, based on the field’s display configuration in Airtable. If lastModifiedTime has no configured result type, it emits string.
  • formula emits number for numeric result types: number, currency, percent or duration. It emits array for array-producing formulas: ARRAYCOMPACT, ARRAYFLATTEN, ARRAYUNIQUE and ARRAYSLICE. Otherwise, it emits string.
  • lookup, multipleLookupValues and rollup emit 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
VersionDatePull RequestSubject
4.8.12026-11-1089120Update dependencies
4.8.02026-11-0490312Add base_collaborators stream
4.7.02026-10-1589000Add incremental sync support for table streams
4.6.432026-10-1388520Update dependencies
4.6.422026-10-0687744Update dependencies
4.6.412026-09-2987090Update dependencies
4.6.402026-09-2286538Update dependencies
4.6.392026-09-1585936Update dependencies
4.6.382026-09-0885385Update dependencies
4.6.372026-08-1884475Update dependencies
4.6.362026-08-1183837Update dependencies
4.6.352026-08-0483351Update dependencies
4.6.342026-07-2882799Update dependencies
4.6.332026-07-2182303Update dependencies
4.6.322026-07-1481711Update dependencies
4.6.312026-07-0780955Update dependencies
4.6.302026-06-2480771Upgrade CDK to 7.23.3
4.6.292026-06-2380374Update dependencies
4.6.282026-06-1679749Update dependencies
4.6.272026-06-0979201Update dependencies
4.6.262026-06-0276518Update dependencies
4.6.252026-04-1376276Rename “concurrent workers” to “concurrent threads” in connector spec
4.6.242026-03-1074540Update dependencies
4.6.232026-02-2473755Update dependencies
4.6.222026-02-1773390Update dependencies
4.6.212026-02-1072993Update dependencies
4.6.202026-02-0372632Update dependencies
4.6.192026-01-2071999Update dependencies
4.6.182026-01-1471506Update dependencies
4.6.172026-01-0870856Add configurable option to include base_id in stream names for uniqueness
4.6.162026-01-0871229Promoting release candidate 4.6.16-rc.1 to a main version.
4.6.16-rc.12025-12-1069778Add HTTPAPIBudget and concurrency_level for improved sync performance
4.6.152025-12-0270296Bump memory for discover to 3GB and check to 1.5GB
4.6.142025-11-2569916Update dependencies
4.6.132025-10-2969029Update dependencies
4.6.122025-10-1465633Update dependencies
4.6.112025-09-0965991Update to CDK v7.0.0
4.6.102025-08-2365352Update dependencies
4.6.92025-08-0964651Update dependencies
4.6.82025-08-0264436Update dependencies
4.6.72025-07-2163281Bump default Memory on DISCOVER to 2.5GB
4.6.62025-07-1563309Adds type property to config_normalization_rules in manifest
4.6.52025-07-1243886Update dependencies
4.6.42025-07-1062894Bump default Memory on DISCOVER to 2GB
4.6.32025-07-0362118Bump default Memory on DISCOVER to 1.5 GB
4.6.22025-06-1761643Bump default Memory on DISCOVER to 1GB
4.6.12025-06-0561394Fix schema issue related to migration
4.6.02025-06-0460875Migrate to manifest-only
4.5.12025-02-1353672Add type for aiText and lastModifiedTime, when result type is null
4.5.02025-02-1253657Promoting release candidate 4.5.0-rc.4 to a main version.
4.5.0-rc.42025-02-0453156Add default type for rollup, lookuo and multiplelookup, add new type manualSort
4.5.0-rc.32025-01-2952624Fix type for multipleLookupValues fields
4.5.0-rc.22025-01-2852595Fix type for datetime fields
4.5.0-rc.12025-01-2749813Update to low-code
4.4.02024-07-1641160Update CDK version to v3.5.2
4.3.12024-07-1641536Update dependencies
4.3.02024-07-1641072Update CDK version to v2.4.0
4.2.62024-07-0941080Update dependencies
4.2.52024-07-0640789Update dependencies
4.2.42024-06-2540290Update dependencies
4.2.32024-06-2240085Update dependencies
4.2.22024-06-0439089[autopull] Upgrade base image to v1.2.1
4.2.12024-05-2938765Fix next_page_token() to correctly adhere to HttpStream interface
4.2.02024-03-1936267Pin airbyte-cdk version to ^0
4.1.62024-02-1235149Manage dependencies with Poetry.
4.1.52023-10-1931599Base image migration: remove Dockerfile and use the python-connector-base image
4.1.42023-10-1931360Update docstings
4.1.32023-10-1331360Update error message for invalid permissions
4.1.22023-10-1031215Exclude bases without permission
4.1.12023-10-1031119Add user-friendly error message when refresh token has expired
4.1.02023-10-1031044Add source table name to output records
4.0.02023-10-0931181Additional schema processing for the FORMULA schema type: Convert to simple data types
3.0.12023-05-1025946Skip stream if it does not appear in catalog
3.0.02023-03-2022704Fix for stream name uniqueness
2.0.42023-03-1524093Update spec and doc
2.0.32023-02-0222311Fix for singleSelect types when discovering the schema
2.0.22023-02-0122245Fix for empty result object when discovering the schema
2.0.12023-02-0122224Fixed broken API Key authentication
2.0.02023-01-2721962Added casting of native Airtable data types to JsonSchema types
1.0.22023-01-2520934Added OAuth2.0 authentication support
1.0.12023-01-1021215Fix field names
1.0.02022-12-2220846Migrated to Metadata API for dynamic schema generation
0.1.32022-10-2618491Improve schema discovery logic
0.1.22022-04-3012500Improve input configuration copy
0.1.12021-12-068425Update title, description fields in spec
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.