Question:

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

I have some questions on the partition.

<ol><li>How to append data to an existing partition in the BigQuery table.</li> <li>How to create a new Partition in an existing BigQuery table if there is already partition present in that BiQuery table.</li> <li>How to do truncate and load data to a partition in the BigQuery table(overwrite data in a partition in the BigQuery table).</li> </ol>

<blockquote>

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

</blockquote>

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

<blockquote>

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

</blockquote>

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

<blockquote>

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

</blockquote>

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