Specifies the method used to insert data into Google BigQuery.

Possible Values

データ型

string

デフォルト値

"Streaming"

解説

This property determines how data is uploaded during insert operations. Choose the insert mode based on your performance, data volume, and staging requirements.

Supported insert modes:

• Streaming: Uses the Google BigQuery streaming API (also called insertAll) to insert rows in real time.
• DML: Uses the Google BigQuery query API to construct and execute INSERT SQL statements for each row.
• Upload: Uses a Google BigQuery load job to upload data from temporary server-side storage.
• GCSStaging: Similar to Upload, but stages files in your own Google Cloud Storage bucket before loading. Requires setting GCSBucket.

When UseLegacySQL is set to true, only Streaming and Upload modes are supported. The legacy SQL dialect does not support DML statements.

Use this property to control how the 本製品 handles insert operations, especially for high-volume or real-time data ingestion scenarios. For detailed guidance on tuning and usage, refer to 高度な統合.