Skip to main content

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 !

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

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


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 !

Reply


Terms & Conditions