SSIS Components for Google BigQuery

Build 24.0.9062

WaitForBatchResults

バルクアップロードAPI を使用するときにジョブの完了を待つかどうか。 InsertMode がUpload に設定されている場合のみ有効です。

データ型

bool

デフォルト値

true

解説

このプロパティは、本製品 がバッチジョブによるステータス報告を待つかどうかを決定します。 By default property is true and INSERT queries will complete only once Google BigQuery has finished executed them. When this property is false the INSERT query will complete as soon as a job is submitted for it.

The default mode is recommended for reliability:

  1. INSERTs will never fail silently. If the 本製品 does not wait for the job to finish, it will never receive an error if the job failed to execute.
  2. If the INSERT batch size is small enough, the 本製品 may submit jobs quickly enough that it hits Google BigQuery's load job limits. This does not happen when waiting for batch results because the 本製品 will not allow more than one job to execute at the same time on the same connection.

You can disable this option to achieve lower delays when inserting, but you must also make sure to obey the Google BigQuery rate limits and check the status of each job to track their status and determine whether they have succeeded or failed.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062