Is it possible to partition tables in BigQuery?
Destination: BigQuery Warehouse
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
Please see our documentation to set this up.