Attribute

UseStreamingInsert (USI)

Purpose

Specifies whether the driver uses the Google BigQuery Streaming API (InsertAll) to execute streaming batch insert operations. This option improves performance for INSERT operations.

Valid Values

1 | 0

Behavior

If set to 1 (enabled), the driver uses the streaming API for batch insert.

If set to 0 (disabled), the driver driver executes row by row insert.

Notes

  • The driver stops subsequent batch insertion if an invalid row is encountered.
  • The Google BigQuery streaming API can be used for INSERT operations only.

Default

1

See also