CODEWITHSUNDEEP
sqlgoogle-bigquerygoogle-cloud-platformpartition
praskovy
praskovy

Reputation: 1

Google BigQuery Partitione Tables - How to create tables automatically daily?

The question is how to let Google BigQuery automatically create partitioned tables on the daily base (one day -> one table, etc.)?

I've used the following command in the command line to create the table: 

bq mk --time_partitioning_type=DAY testtable1

The table1 appeared in the dataset, but how to create tables for every day automatically?

Upvotes: 0

Views: 525

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33745

From the partitioned table documentation, you need to run the command to create the table only once. After that, you specify the partition to which you want to write as the destination table of the query, such as testtable1$20170919.

Upvotes: 1

Related Questions