Airtable

Connect Airtable to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

Connect Airtable

Open the catalogue. In the console, go to Data · Connections and press New connection.
Choose Airtable. It is listed under product and operations; you can also search for it by name.
Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

What the connection form asks for. Required fields are marked; the rest are optional.

Field	Type	Required	Description
Authentication	one of 2 options	No
Add Base ID to Stream Name	boolean	No	When enabled, includes the base ID in stream names to ensure uniqueness. Use this if you have cloned Airtable bases with duplicate table names. Note that enabling this will change stream names and require a full refresh. Default `false`.
Number of Concurrent Threads	integer	No	Number of concurrent threads for syncing. Higher values can speed up syncs but may hit rate limits. Airtable limits to 5 requests per second per base. Default `5`.

Choose one of the following. Each asks for its own fields.

OAuth2.0

Field	Type	Required	Description
Access token	string, secret	No	Access Token for making authenticated requests.
Client ID	string, secret	Yes	The client ID of the Airtable developer application.
Client Secret	string, secret	Yes	The client secret of the Airtable developer application.
Refresh token	string, secret	Yes	The key to refresh the expired access token.
Token expiry date	string	No	The date-time when the access token should be refreshed.

Personal Access Token

Field	Type	Required	Description
Personal Access Token	string, secret	Yes	The Personal Access Token for the Airtable account.

Something unclear or out of date? Tell us, and we will fix the page.