Oct 26, 2021 07:08 AM
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!
Oct 26, 2021 08:11 AM
Oct 26, 2021 08:38 AM
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.
Mar 31, 2023 07:11 AM
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.
May 03, 2023 07:52 AM
You can use the Skyvia cloud data integration platform to connect BigQuery and Airtable with no coding. It is freemium