Bigquery Python API create partitioned table by specific field

Question

I need to create a table in Bigquery partitioned by a specific field. I have noticed that this is only available via API Rest. Is there a way to do this via Python API?

Any help?

Use a CREATE TABLE statement.

Elliott Brossard
– Elliott Brossard

2018-07-11 11:32:52 +00:00
Commented Jul 11, 2018 at 11:32 — Elliott Brossard
– Elliott Brossard, Commented Jul 11, 2018 at 11:32

Graham Polley · Accepted Answer · 2018-07-11 10:42:42Z

2

My guess is that the docs just haven't been updated yet (not that rolling a http request and calling the API would be hard anyway), because if you look at the code for the BigQuery Python client library, it does indeed appear to support specifying the field when creating a partitioned table:

answered Jul 11, 2018 at 10:42

Graham Polley

14.8k9 gold badges54 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stewart_R · Accepted Answer · 2019-07-30 12:30:29Z

2

Expanding on Graham Polley's answer: You can set this by setting the time_partitioning property.

Something like this:

import google.cloud.bigquery as bq
bq_client = bq.Client()
dataset = bq_client.dataset('dataset_name')
table = dataset.table('table_name')
table = bq.Table(table, schema=[
  bq.SchemaField('timestamp', 'TIMESTAMP', 'REQUIRED'),
  bq.SchemaField('col_name', 'STRING', 'REQUIRED')])

table.time_partitioning = bq.TimePartitioning(field='timestamp')

bq_client.create_table(table)

answered Jul 30, 2019 at 12:30

Stewart_R

14.5k11 gold badges66 silver badges118 bronze badges

Collectives™ on Stack Overflow

Bigquery Python API create partitioned table by specific field

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related