“Write append” options bigquery

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

REPLACE TABLE `dataset.mytable` 
AS 
SELECT 1;

this way you fully replace on each run.

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