Create Bigquery partitioned table using Python and API

Question

I would like to create a partitioned table in BigQuery from a Python script using client.create_table() but I get the error message

TypeError: create_table() got an unexpected keyword argument 'time_partitioning'`

Would be great if someone could tell me where I am going wrong.

This is the code I am using:

client = bigquery.Client.from_service_account_json('path/to/key')
...
data_ref = bigquery.DatasetReference(PROJECT_ID, DATASET_ID)
table_ref = bigquery.TableReference(data_ref, new_TABLE_ID)
table = bigquery.Table(table_ref, schema = SCHEMA) 
new_table = client.create_table(table, time_partitioning = True)

This is some documentation I used

Is there a reason not to use a CREATE TABLE statement instead? I feel like that would be easier. See the DDL documentation. — Elliott Brossard
– Elliott Brossard, Commented Apr 27, 2018 at 11:40

db_gg · Accepted Answer · 2018-04-27 11:50:58Z

1

FYI solved with

client = bigquery.Client.from_service_account_json('path/to/key')
... 
data_ref = bigquery.DatasetReference(PROJECT_ID, DATASET_ID)
table_ref = bigquery.TableReference(data_ref, new_TABLE_ID)
table = bigquery.Table(table_ref, schema = SCHEMA)
table.partitioning_type = 'DAY' 
client.create_table(table)

answered Apr 27, 2018 at 11:50

db_gg

1291 silver badge11 bronze badges

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

Collectives™ on Stack Overflow

Create Bigquery partitioned table using Python and API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related