Cannot Set Destination Table With Bigquery Python Api

I'm recently getting the following BigQuery error when using the Python API: google.api_core.exceptions.BadRequest: 400 configuration.query.destinationTable cannot be set for scrip

Solution 1:

Thanks for the responses, comments were indeed in the right direction. In BigQuery scripting means https://cloud.google.com/bigquery/docs/reference/standard-sql/scripting.

And that is what is not allowed, and my query had:

DECLARE capital int64 default 10000000;

So, removing the line above was the fix in my case.

Interesting thing is that even in the web interface

• If you use scripts the interface won't allow to save to table:

• In contrast, when not using script statements, you should see:

Solution 2:

error is self-descriptive. scripts do not allow destination table to be set - instead you should use DML/DDL

workaround is to reset job_config with no destination table in it