Specifies the prefix of the dataset used to store temporary tables during bulk UPDATE or DELETE operations.

データ型

string

デフォルト値

"_CDataTempTableDataset"

解説

The 本製品 uses Google BigQuery MERGE statements to perform bulk UPDATE and DELETE operations. These operations require staging the modified data in a temporary table. This property defines the prefix used to name the dataset where those temporary tables are created.

The full dataset name is derived by appending the region of the target table to the specified prefix. This ensures that the temporary and target tables reside in the same region, which is required by Google BigQuery and helps avoid cross-region data transfer charges.

For example, if this property is set to the default value (_CDataTempTableDataset), the 本製品 generates region-specific datasets by appending the region name to the prefix.

/* Used for tables in the US region */
_CDataTempTableDataset_US
/* Used for tables in the Asia Southeast 1 region */
_CDataTempTableDataset_asia_southeast1

This ensures that temporary tables used during bulk operations are stored in the same region as the target tables. Google BigQuery requires this for MERGE operations, and it helps avoid additional latency or data transfer costs.

Each Google BigQuery region must have its own temporary dataset, based on the specified prefix.

Use this property to customize the prefix used for temporary datasets in bulk write operations. This can help align with naming conventions or avoid naming conflicts in shared environments.