title: BigQuery - remove unused column from schema
body: <p>I accidentally added a wrong column to my BigQuery table schema.</p>
  
  <p>Instead of reloading the complete table (million of rows), I would like to know if the following is possible:</p>
  
  <ul>
  <li>remove bad rows (rows with values contains the wrong column) by running a "select *" query on the table with some kind of filter, and saving result to same table.</li>
  <li>removing the (now) unused column.</li>
  </ul>
  
  <p>Is this functionality (or similar) supported?
  Possibly the "save result to table" functionality can have a "compact schema" option.</p>