
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>Answer1:<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
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