eilalan
Reputation: 689
looking for a way to partition bigQuery tables by column value
I am working with genomic data. There is no outdated data so i can not partition by date and the data mass is large.
Is there a way to partition by column value? can it be automated somehow? I would like to use it for visualization and the preferred size is 1 GB table ay idea?
thanks, eilalan
Upvotes: 1
Views: 158
Answers (1)
Mikhail Berlyant
Reputation: 172944
As of today - there is no way to partition table by column value
There is a Partition on non-date field - feature request for this that you can star to vote for it
Upvotes: 2
Related Questions
- How do I create a partitioned table in bigquery
- Partitioning BigQuery table based on nested column
- Partitioning based on column data?
- BigQuery: Split table based on a column
- create BigQuery external tables partitioned by one/multiple columns
- BigQuery: Saving query result to partitioned table using cloud client
- Partitioned table BigQuery (with custom field)
- Partitioned tables in BigQuery
- Is there a way to partition a table created from a query in BigQuery?
- BigQuery Dynamic Table Partitions