title: BigQuery - Delete rows from Partitioned Table
body: <p>I have a Day-Partitioned Table on BigQuery. When I try to delete some rows from the table using a query like:</p>
  
  <pre><code>DELETE FROM `MY_DATASET.partitioned_table` WHERE id = 2374180
  </code></pre>
  
  <p>I get the following error: </p>
  
  <blockquote>
    <p>Error: DML statements are not yet supported over partitioned tables. </p>
  </blockquote>
  
  <p>A quick Google search leads me to: <a href="https://cloud.google.com/bigquery/docs/loading-data-sql-dml" rel="noreferrer">https://cloud.google.com/bigquery/docs/loading-data-sql-dml</a> where it also says: <strong>"DML statements that modify partitioned tables are not yet supported."</strong> </p>
  
  <p>So for now, is there a workaround that we can use in deleting rows from a partitioned table?</p>