CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
user_1357
user_1357

Reputation: 7940

BigQuery: Saving query result to partitioned table using cloud client

I am currently using following client as suggested in BigQuery documentation com.google.cloud:google-cloud-bigquery:1.36.0

Looks like specifying time partitioning for destination table is not yet supported in this client. Is this expected or do I need to use old client com.google.apis:google-api-services-bigquery to use this feature?

Upvotes: 0

Views: 2001

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33765

You don't need to set specific attributes in the client. Use a CREATE TABLE AS SELECT DDL statement, e.g.:

CREATE TABLE dataset.new_table
PARTITION BY DATE(timestamp_column) AS
SELECT x, y, z, timestamp_column
FROM dataset.existing_table

Upvotes: 6

Related Questions