19 Mar 22 ·  dan-irving in General ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Solved: Cannot set write disposition in jobs with DML statements in Google BigQuery WebUI Console

When trying to delete data from a table in Google BigQuery web user interface, you get the below error message:

Cannot set write disposition in jobs with DML statements

Solution:

1. Open "Query Settings" in the Web UI


2. In the Settings Page, you should see "Save query results in a temporary table" selected. Toggle that option to "Set a destination table for query results" and then flip it back again to the "Save query results in a temporary table", Then hit "Save"


Run your delete / other DML query and it should work fine. Its a known user interface bug that causes this error

dan-irving

posted on 19 Mar 22

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds