How to update a scheduled script query including DML statements in BigQuery?

Question

I have a couple of scripts scheduled as scheduled queries in BigQuery. I need to update some of the scripts and sometimes I run into an error where BigQuery doesn't seem to recognize my queries as scripts. According to the documentation, a query that includes DML/DDL statements should not have a destination table configured. However, BigQuery is forcing me to input a destination table, which I don't think I am supposed to do, as per above-mentioned documentation and since my script already includes an INSERT statement.

Here is a screenshot of what I see:

BigQuery screenshot trying to update a DML scheduled script

On the left I have highlighted my script, which included DML, and on the right, the options that BigQuery is forcing me to fill.

What should I do in order to correctly update a script with DML statements, without having to input a destination table in the options?

question from:https://stackoverflow.com/questions/65876176/how-to-update-a-scheduled-script-query-including-dml-statements-in-bigquery

Answer 1

Waitting for answers