Relative Content

Tag Archive for databasegoogle-cloud-platformgoogle-bigquerydefaultalter-table

How to Add a New Default Column to an Existing Table in Google Big Query?

Current Situation I have a bigquery table called orders containing some columns, and about 0.5 million rows. What I Need The table needs to have a new column, called ingestion_time, of type DATETIME that would default to the current local time of Singapore (UTC+8h) at the time of ingesting each row. The default value is […]