Bigquery Error: "Cannot Set Write Disposition in Jobs with Dml Statements"
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...
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 Answer
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.
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
