Airtable logo

Airtable Connector

Sync bases, tables, and records from your Airtable workspace into your data warehouse. Supports OAuth and Personal Access Token authentication with automatic token refresh.

SourceBronze
Start FreeView Documentation

Why Supaflow

All connectors included

No per-connector fees. Every connector is available on every plan.

Pay for compute, not rows

Credit-based pricing. No per-row charges, no MAR surprises.

One platform

Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.

Capabilities

OAuth and Personal Access Token Authentication

Connect via OAuth 2.0 browser-based flow (recommended) with automatic token refresh, or use a Personal Access Token created at airtable.com/create/tokens. Required scopes: data.records:read and schema.bases:read.

Base and Table Discovery

Discovers all Airtable bases and tables accessible to the connecting account. Each table in each base is available for selection.

Incremental Sync via lastModifiedTime

Tables with a lastModifiedTime field type support incremental sync. Airtable tables without this field are synced via full refresh. Add a "Last modified time" field in Airtable to enable incremental mode.

Configurable Schema Refresh

Schema refresh interval ranges from 0 (every pipeline run) to 10080 minutes (weekly). Set to 0 if you frequently add or remove fields in Airtable.

Supported Objects

Airtable Data

Bases

All Airtable bases the connecting account or token has access to.

Tables

All tables within accessible bases, including fields and records.

Fields

All field types supported by Airtable, including attachments, lookups, and formulas.

How It Works

1

Choose authentication method

Select OAuth (recommended) for browser-based authentication with automatic token refresh, or Personal Access Token for server-to-server authentication. For PAT, create a token at airtable.com/create/tokens with data.records:read and schema.bases:read scopes.

2

Authorize and connect

For OAuth, click Authorize to open the Airtable sign-in flow and grant Supaflow access to your bases. For PAT, paste the token (starts with "pat...") into the field.

3

Test and save

Click Test & Save to verify the connection. Supaflow discovers your bases, tables, and fields. Select the tables you want to replicate.

Use Cases

Warehouse Airtable project data

Replicate project management, inventory tracking, or CRM data from Airtable bases into your warehouse for SQL-based reporting and joins with other data sources.

Cross-tool analytics

Combine Airtable records with data from Salesforce, HubSpot, or other sources in your warehouse to build consolidated dashboards.

Airtable backup and archival

Maintain a warehouse copy of Airtable data as a backup or for compliance requirements that exceed Airtable native retention.

Frequently Asked Questions

How do I enable incremental sync for an Airtable table?
Add a field with type "Last modified time" to the table in Airtable. Then refresh the schema in Supaflow (set Schema Refresh Interval to 0). The connector uses this field as the cursor for incremental sync.
What are the Airtable API rate limits?
Free and Plus plans allow 5 requests per second per base. Pro and Enterprise plans have higher limits. The connector automatically retries with backoff when rate limited.
Why are some bases not appearing?
For OAuth, ensure you granted access during authorization. For Personal Access Token, verify the token has schema.bases:read scope and that specific bases are added to the token access list at airtable.com/create/tokens.
How are Airtable field types mapped to my destination?
Airtable field types are mapped automatically. Text fields become strings, numbers become doubles or decimals, checkboxes become booleans, dates become timestamps, and complex types like linked records, attachments, and multiple selects become JSON arrays.
Can I sync Airtable data to Snowflake?
Yes. Supaflow loads Airtable data into Snowflake, S3, or other supported destinations. You can also run the pipeline natively inside Snowflake using Snowpark Container Services -- your data never leaves your Snowflake account.
What happens if I change field types in Airtable?
Supaflow detects schema changes automatically on the next sync. Type widening (e.g., number to text) is handled gracefully. Breaking type changes may require manual review in the schema evolution settings.

Related Resources

Airtable Source DocumentationView docsRun natively inside SnowflakeRead postGetting Started GuideView docs

Need a connector we don't support yet?

Build one with AI-powered Connector Dev Skills.

Learn More About the Connector SDK

Load into any of these destinations

Salesforce

Salesforce

Snowflake

Snowflake

PostgreSQL

PostgreSQL

S3

S3

S3 Data Lake

S3 Data Lake

Salesforce Marketing Cloud

Salesforce Marketing Cloud