BigQuery - remove unused column from schema
<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>