We can easily add new column for a table in BigQuery:
SQL
x
2
1
ALTER TABLE mydataset.mytable2
ADD COLUMN new_col STRINGBut when you want to delete or rename an existed column, there is no SQL to implement it. The only way to delete or rename an existed column is to use the bq command:
Console
1
6
1
bq show --format=prettyjson mydataset.mytable > schema.json2
# Edit the schema.json to only leave a list of columns3
bq mk --table mydataset.new_mytable schema.json4
# Export data from `mytable` to `new_mytable`5
bq rm --table mydataset.mytable6
bq cp --table mydataset.new_mytable mydataset.mytableAnd remember to backup your data before operating!