BigQuery batch loading into partitioned table

Question

I'm loading data into BQ partitioned table from GCS. Every day one date partition. How I can use WRITE_TRANCATE for partition, not for the whole table? I want to overwrite partition data. How it should be implemented?

I'm using code like this https://cloud.google.com/bigquery/docs/samples/bigquery-load-table-partitioned

Sergey Geron · Accepted Answer · 2021-05-27 13:40:50Z

1

Try to specify the partition you want to overwrite (instead of a whole table):

table_id = "your-project.your_dataset.your_table_name$20210527"

answered May 27, 2021 at 13:40

Sergey Geron

10.5k4 gold badges28 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

BigQuery batch loading into partitioned table

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