BigQuery Scheduled query (script) loop: needs destination table to be saved, but run fails because of set destination table

Question

I had a scheduled query that did not have a destination table set, as it is created in the script with the create table command (in my understanding that is called a script in the BQ environment). I had to modify the script a bit - which did not affect the create part, and I wanted to update the existing scheduled query with the modified version.

However I could only update the scheduled query if I gave a destination table (otherwise the Update button is inactive): "A destination table is required to save scheduled query options.". So I saved it with defining a "destination table".

When running the scheduled query later, I got the following error: "Invalid value: configuration.query.destinationTable cannot be set for scripts; JobID: ..."

For me it seems that I cannot save the scheduled query without a destination table, and I cannot run it with a destination table.

It seems like a catch 22, am I missing something here? How could this script/scheduled query be updated and run?

Thanks!

Answer 1

等待大神答复