How can you connect BigQuery tables to Airtable?

[Tom_McD]

Hey there!

So I am trying to figure out if this is even possible, we are trying to hook up some database tables (BigQuery) to airtable. I have gone through the API docs and I see there could be a method of uploading JSONs periodically to airtable, but I feel like there are a lot of limitations there. I’m wondering if anyone has done something similar to this?

We use our database as a source of truth, and ideally want to clone the tables from there so that they can be used in airtable freely.

Any thoughts / advise is appreciated, thanks!

[ScottWorld]

I would check out Integromat, which has full BigQuery support:

Integromat

BigQuery Integrations

Integromat gives you the ability to integrate BigQuery with many other services.

[Bill_French]

Tom_McD:

We use our database as a source of truth, and ideally want to clone the tables from there so that they can be used in airtable freely.

You need to define “can be used in Airtable freely”, but assuming this is a read-only utilization, it’s relatively simple if you are comfortable with script actions and webhooks.

You need an Airtable webhook to listen for Big Query change events and act on those events (with a script action) to pull updated rows from your various Big Query tables using its API.

You could use something like Integromat but there are some downsides - choose wisely.

[Ernestostvo]

I stumbled upon your post and thought I might be able to help. Although I haven't tried connecting BigQuery tables to Airtable before, I found a resource that might be useful for you. I came across a guide on how to integrate Google BigQuery with Airtable, which could potentially help you clone your tables from your database into Airtable.
The guide explains how you can use Google Apps Script and the BigQuery API to transfer data from BigQuery tables to Airtable. It seems like a straightforward process that involves setting up the script, configuring your Airtable base and API key, and defining your BigQuery SQL query. You can find more details and a step-by-step guide in the link I provided.

[MichaelTomar]

You can use the Skyvia cloud data integration platform to connect BigQuery and Airtable with no coding. It is freemium