Gary Chen
Reputation: 21
BigQuery Partition By List
Does BigQuery support partition by list or by range? The online document seems to say that it only supports partition by date. Can someone confirm?
Upvotes: 2
Views: 187
Answers (1)
Mikhail Berlyant
Reputation: 172944
Currently, BigQuery support partitioning only by date!
https://cloud.google.com/bigquery/docs/partitioned-tables
See also request for supporting non-date partitioning
Vote on it if you need this feature
https://issuetracker.google.com/issues/35905817
Upvotes: 2
Related Questions
- BigQuery Partition table
- Apply partitioning over a list in bigquery
- SQL BigQuery Using Partition By on multiple columns
- How do I create a partitioned table in bigquery
- BigQuery table partition
- BigQuery full table to partition
- BigQuery - Partitioning necessity
- Query BigQuery table partitioned by Partitioning Field
- Create Partition table in Big Query
- BigQuery Dynamic Table Partitions