Connect DataBusiness Apps
Airtable
Airtable is in Preview in the connection wizard: it is built on Airtable’s documented API and has not yet been proven against a live account, so check the imported tables before relying on them. Every table in the base can be imported; fields become fields.<name> columns.
-
In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.
-
Pick Airtable on that page (search or browse by category).
-
Fill in the connection details below, then test the connection and save.
Connection details
Section titled “Connection details”| Field | What to enter |
|---|---|
| Base ID | In the base’s address: airtable.com/app…/ e.g. appXXXXXXXXXXXXXX |
| Personal access token | airtable.com/create/tokens — scopes data.records:read and schema.bases:read, with access to this base. Stored encrypted and never shown again. |
Test Connection lists the tables with these values; nothing is saved until you import.
Tables
Section titled “Tables”Pick the tables to import — each one becomes a table in the source:
Find tables lists the tables in your Airtable account (up to 1,000); every one is picked to begin with, and each you keep becomes a table named after it — one source imports up to 200 of them. A refresh reads the same tables under the same names, even if one is renamed in Airtable.
Every table is read through all of its pages, nested fields become parent.child
columns, and the whole set is imported at once: the import’s row and size limits
count the picked tables together, and if they pass one, nothing is imported and
the message says which table and which limit. Refresh the source on a schedule,
or by hand, to re-read every table; a table that comes back empty is refused
rather than emptied unless you allow it. Nothing is ever written to Airtable.
The requests follow Airtable’s API reference.
Related
Section titled “Related”- Connector catalog — everything DataSquares connects to.
- Quickstart — from connection to shared dashboard.