ZapQuery Getting Started Guide: How to Run SQL on Airtable


Important: WE NEVER STORE YOUR DATA, WE NEVER SAVE YOUR DATA, WE DON’T LOOK AT YOUR DATA. Our system is totally a pass-through. Your data is safe with us because WE DON’T STORE IT. We just wanted to make that clear.


Step 1 – Register for ZapQuery


Step 2 – Connect Airtable to ZapQuery

Part of getting ready to run SQL on Airtable is obviously going to be connecting to Airtable. This data from your base will be necessary to populate the sql results. Follow the instructions below.


Go to Airtable, log in, and click on Account.


Click on the Airtable API link below, and select the database that you want to query. When you begin to run SQL on Airtable, keep in mind that you will need to update the base ID if you want to run SQL on other Airtable bases you may own. The ability to run queries on multiple bases is coming in the future.

https://airtable.com/api

Once you select your base, a page will come up. Look for the text “The ID of this base is…” and copy the green text like you see below.

Ex:
The ID of this base is app*****************.

Copy that ID and paste both the personal API key and the base ID into ZapQuery like you see below.


Step 3 – Run your first query

Alright, now that you have set up Airtable, you’re ready to run SQL on Airtable! Click on “Queries” at the top.


Step 4 – Save a query, learn how to handle errors, and learn to dump to Excel

NOTE: All SQL is T-SQL like you would find in Microsoft SQL server. So just to be clear, to run SQL on Airtable using ZapQuery, you must write T-SQL, for now. We may add other engines later. If you have an opinion on this topic, please drop us a line at support@zapquery.com.

If your query barfs, click on the google link and your error will come up with help.

The text box for the query title is the narrow rectangle box text box in the middle just above the save button. You can blame us for that one. We will make it better later we promise. Also note the export to CSV button below.


Step 5 – Pipe the data to Zapier and do what you want with it

In this example, we’re going to email it to ourselves.

What good is being able to run SQL on Airtable if you can’t do anything with the data? To that end, we’ve integrated into Zapier for you, so you can pipe the data into other things either as HTML tables or you can pull in summary queries and use the values in your logic.



Step 6 – Tell your friends! (Or your enemies)

Thanks for reading our guide. You can now run SQL on Airtable!