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

1 Answer

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy