Default values for columns in Big Query Tables

Question

Is there a way to set default values for columns in tables in big query? I would like to set 'false' as a default value for a column of boolean data type.

Answer 1

A nullable column can (trivially) have a NULL default value, but there is no other notion of default in BigQuery (you either insert a particular value or omit the value and it will have the NULL value).

That said, if you want to wrap your raw table in a View, you can map a NULL column value to any default that you like.