如何将数据附加到BigQuery表中的现有分区。

您可以通过Web UI或API或您选择的任何客户端执行此操作 - 方法相同 - 只需设置您的目的地表与各自的分区装饰，如下面的例子

  yourProject.yourDataset.youTable $ 20171010 
 

请注意：要追加数据 - 您需要使用追加到表 for 写入首选项

如何在现有的BigQuery表中创建新的分区if该BiQuery表中已经存在分区。

如果您在目标表的装饰器中设置的分区尚不存在 - 它会为您添加

如何将数据截断并将数据加载到BigQuery表中的分区（覆盖BigQuery表中分区中的数据）。

要截断并加载到特定的分区，您应该使用覆盖表为写入首选项

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).

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

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