CODEWITHSUNDEEP
google-bigquery
JJZ
JJZ

Reputation: 395

When is the feature of partitioning on integer column available in BIGQUERY table?

Do we know when google will enable partitioning on integer column in BIGQUERY table? And can we partition BIGQUERY table after it is created or it has to be partitioned at the same time when the BIGQUERY table is created?

Many thanks.

Upvotes: 2

Views: 7256

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173046

So called Integer range partitioned tables are available already as Beta in a pre-release state

Table must be set as partitioned during its creation as in example below 

CREATE TABLE `project.dataset.table`
PARTITION BY RANGE_BUCKET(customer_id, GENERATE_ARRAY(0, 100, 10)) AS 
SELECT 1 AS customer_id, DATE '2019-10-01' AS day

See more details in Creating and using integer range partitioned tables

Upvotes: 8

Related Questions