Specifies whether the provider should wait for Google BigQuery batch load jobs to complete before returning from an INSERT operation.

Data Type

bool

Default Value

true

Remarks

This property only applies when InsertMode is set to Upload.

By default, this property is set to true, meaning the server waits until the batch load job has completed. This ensures that any errors encountered during execution are detected and reported immediately. It also helps manage Google BigQuery load job limits by preventing multiple concurrent jobs on the same connection.

If this property is set to false, the server submits the load job and returns control to the application immediately without checking the final status. While this may reduce perceived latency, it introduces the risk of silent failures and requires the application to manually track job status. It also increases the chance of exceeding Google BigQuery rate limits if multiple jobs are submitted too quickly.

Leave this property enabled for more reliable insert behavior and automatic error handling. Disable it only if your application handles job monitoring and rate-limiting logic independently.