CODEWITHSUNDEEP
google-bigquery
Hemant
Hemant

Reputation: 197

How to append data to an existing partition in BigQuery table

We can create a partition on BigQuery table while creating a BigQuery table.

I have some questions on the partition.

  1. How to append data to an existing partition in the BigQuery table.
  2. How to create a new Partition in an existing BigQuery table if there is already partition present in that BiQuery table.
  3. How to do truncate and load data to a partition in the BigQuery table(overwrite data in a partition in the BigQuery table).

Upvotes: 2

Views: 2656

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172944

How to append data to an existing partition in the BigQuery table.

Either you do this from Web UI or with API or with any client of your choice - the approach is the same - you just set your Destination Table with respective partition decorator, like below as an example

yourProject.yourDataset.youTable$20171010

Please note: to append your data - you need to use Append to table for Write Preference under Advanced Options (which you need to expand)

How to create a new Partition in an existing BigQuery table if there is already partition present in that BiQuery table.

If the partition you set in decorator of destination table does not exist yet - it will be added for you

How to do truncate and load data to a partition in the BigQuery table(overwrite data in a partition in the BigQuery table).

To truncate and load to a specific partition - you should use Overwrite table for Write Preference

Upvotes: 2

Related Questions