Help

BigQuery import and upsert in airtable table

631 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Nocode34130
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello,

I try to import and upset data from BigQuery to an airtable table.

I use Skyvia or Make and the first import works fine....

My problem is the Upsert case !

When I run a new import, the record are duplicated and not updated.

First, is there a method to compare the two base and write only the new record in airtable?

Second, is there a method to compare the two base and update in airtable only the modified record from bigquery ? 

May be do i have to script that in an automation ?

Thanks for your help !

2 Replies 2

Make has an upsert module for Airtable. If you need help using it, check out this episode of the BuiltOnAir podcast where I talk about importing files into Airtable:

https://www.youtube.com/watch?v=cMA4GPj4iNE

airtable #on2air #builtonair 7/18/2023 - BuiltOnAir Live Podcast Full Show - S15-E02 ___________________________ The BuiltOnAir podcast is a live weekly show highlighting everything happening in the Airtable universe. Check us out at BuiltOnAir.com/join. Join our community, join our Slack channel

Hi ! @ScottWorld  

Thanks a lot for your video ! I tried this but with bigquery instead of  CSV module... it doesn't work.

I tried to convert my bigquery table to a csv before the airtable's search and upsert modules but doesn't work too... 

My bigquery table is already in "csv like" format with comma and column so I don't know how to replace with the toString() expression that I don't need in the CSV module !