How to Add a Column in BigQuery

In BigQuery (as in many other SQL databases), in order to add a new column you need to use an alter table as below:

alter table Database_test_IB1.employee add column last_bonus_date date;

The value of the new column will be NULL for all the existing rows in the table.

IN THIS PAGE