Google BigQuery Streaming API
- Last Updated: May 26, 2023
- 1 minute read
- DataDirect Connectors
- JDBC
- Google BigQuery 6.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
UseStreamingInsert connection property. When this connection property is
set to true, the driver uses the tabledata.insertAll method
for streaming batched inserts. The request payload sent to the API is in a JSON
format.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.