Question
Is it possible to partition tables in BigQuery?
Environment
Destination: BigQuery
Answer
Yes, using BigQuery it is possible to partition the tables.
There are two types of table partitioning:
- Tables partitioned by ingestion time: Tables partitioned based on the data's ingestion (load) date or arrival date
- Partitioned tables: Tables that are partitioned based on a
TIMESTAMP, orDATE, orINTEGERcolumn
Please see our BigQuery partitioned tables Documentation to set this up.