Airtable + SQL: Querying Airtable with DataStation
Requires DataStation 0.8.0+.
Database initialization [Optional]
If you want to follow along with this tutorial verbatim, create a new base in Airtable and enter some basic data.
Airtable API token
If you don't already have an Airtable API token, go to airtable.com/account, generate and save it.
Data source setup
Now inside DataStation create a new data source in the left sidebar.
Give it a nice name so you can easily find it later. And select Airtable in the Vendor dropdown.
Then enter your Airtable API token.
Panel setup
Now create a new panel and select the Database type. You can fill in Base ID, Table ID, and View ID manually or you can just paste your Airtable URL into the Base ID column and it will fill out the rest.
Run a query
When querying Airtable you can leave the filter blank to select all rows or you can use Airtable's filter language to fetch only a subset of rows in a table.
SQL query on top
Now that the data is loaded in DataStation we can use DataStation's scripting abilities to run a program using the Airtable data. We'll run a SQL program that counts the number of applied applicants.
Create a new Code panel, select SQL as the language, enter this query and hit run.
SELECT "Notes", COUNT(1) n FROM DM_getPanel(0) GROUP BY "NOTES"
From here you can generate graphs, do more analysis, or export results to a file or HTTP server.
About this page
See an error or want to add a clarification? This page is
generated from this file on Github.
Last edited Jun 03, 2022.