Another option, besides re-creating the table and then doing "INSERT INTO <Target_Table> SELECT * FROM <Source_Table>" is to use "bq cp mydataset.mytable mydataset2.mytable2". It's there in the google docs, not sure how I missed it. Seems it should be simpler/quicker than the "INSERT INTO ..." option though I have not compared.