bigquery schema


create table

bq mk --time_partitioning_type=DAY
--require_partition_filter
--schema test_table.schema
--table sample_project:test-data-set.test_table

update table schema

bq show --schema --format=prettyjson sample_project:test-data-set.test_table > ./test_table.schema

vi test_table.schema

bq update sample_project:test-data-set.test_table test_table.schema