Is there a way to create custom day partition on BigQuery Tables?

Question

I'm new to BigQuery and I'm trying to create table with day partition other than the default that google is allowing. Is it possible to back date the DAY partition? Since I'm trying to load historical data I wouldn't be helpful using today for those partition. I'm creating table in BigQuery through Google Storage.

Thanks!

Answer 1

Yes, you can use partition decorators to insert data into a specific partition: https://cloud.google.com/bigquery/docs/partitioned-tables#addressing_table_partitions.

bq load 'mydataset.table$20160519' ...