How do I create a partitioned table in bigquery
Take a look at timePartitioning property of table resources.
You can experiment with it I think :o)
More about it in Partitioned Tables and Creating and Updating Date-Partitioned Tables
You can run this code in the UI / CLI to create a table with partitioning.
bq query --use_legacy_sql=false '
CREATE TABLE dw_prod.example_table (
company STRING,
value FLOAT64,
ds DATE)
PARTITION BY ds
OPTIONS(
expiration_timestamp=TIMESTAMP "2028-01-01 00:00:00 UTC",
description="Example table create in BQ CLI",
labels=[("example","summary")]
);'