“Write append” options bigquery

You should have your scheduled query written with replace in mind:

REPLACE TABLE `dataset.mytable` 

this way you fully replace on each run.

Update: You may use MERGE statement to skip existing rows and add only new ones.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top