Skip to main content

BigQuery import and upsert in airtable table

  • August 10, 2023
  • 2 replies
  • 48 views
N
Forum|alt.badge.img+4

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

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • August 10, 2023

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

N
N
Forum|alt.badge.img+4
  • Nocode34130
  • Author
  • Inspiring
  • August 10, 2023

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 !

Terms & ConditionsAccessibility statement