title: Delete tables in BigQuery Cloud Console
body: <p>I am trying to delete data from Bigquery tables and facing a challenge. At the moment only one date partitioned table drops/deletes at a time. Based on some research and docs on google, I understand I need to use DML operations.</p>
  <p>Below are the commands that I used for deletion and it doesn’t work</p>
  <p>1.delete from <code>bigquery-project.dataset1.table1_*</code></p>
  <p>2.drop table <code>bigquery-project.dataset1.table1_*</code>;</p>
  <p>3.delete from <code>bigquery-project.dataset1.table1_*</code> where _table_suffix='20211117';</p>
  <p>The third query works for me and it deletes only for that particular date.</p>
  <p>For the 1 and 2 queries, I’ve got a exception saying <strong>“Illegal operation (write) on meta-table bigquery-project.dataset1.table1_”</strong></p>
  <p>How would I go about deleting over 300 date partitioned tables in one go?</p>
  <p>Thanks in advance.</p>