BigQuery error: "Cannot set write disposition in jobs with DML statements"

Viewed 4063

I am trying to delete data from BQ table, and statement which worked yesterday stopped working today with the error:

delete from `project.my_dataset.my_table` where my_id='value'

Cannot set write disposition in jobs with DML statements
1 Answers

It's been answered in here Just recheck "Save query results in a temporary table" in "Query Settings" and save those settings. I tried and it works.

Related