Google BigQuery Streaming API
- Last Updated: May 26, 2023
- 1 minute read
- DataDirect Connectors
- ODBC
- Google Bigquery 8.0
- Documentation
The driver supports the Google BigQuery Streaming API for executing batch inserts. The BigQuery Streaming API provides increased throughput and allows the driver to manage insert operations efficiently.
You can enable the driver to use the Streaming API with the Use Streaming
Insert (
UseStreamingInsert) connection option. When this connection option is
set to 1, the driver uses the tabledata.insertAll method for
streaming batched inserts. Note: When using the Streaming API for insert operations, the rows
are queued and appear in the table after a delay. The duration of the delay varies and can
go up to 30 minutes. You must not modify the table or run other operations on the table
while there are rows in the streaming queue. Changing the table's metadata or running DML
operations can cause uncommitted streaming rows to be lost.
Before enabling the driver to use the Streaming API, prerequisites described in the Google Cloud BigQuery Streaming API reference must be met.