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 22Enjoy 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
Post Comment