Near Real-time Data Loading using Streaming

Last updated on Nov 02, 2023
On This Page

Hevo offers you the option to load data into your BigQuery Destination in near real-time by streaming it. Using BigQuery’s streaming APIs, Hevo writes the data to your BigQuery Destinations with the insertAll method.

Streaming offers the advantage of making data available for querying without having to wait for a task to finish loading data into BigQuery. However, you must also consider the following limitations before choosing to stream the data:

  • Streaming writes incur additional cost for you. Read Streaming pricing.

  • BigQuery does not support using streaming APIs if billing is not enabled for the GCP project. Refer to the section, Enable billing for your Google Cloud project for the steps to do this.

  • Once enabled, this option cannot be disabled for the Destination.

  • If streaming is selected, deduplication of Events cannot be enabled.

  • If the same tables are referred to in a different Destination, uniqueness cannot be guaranteed.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jun-19-2023 NA Added information that billing must be enabled on the project to use streaming inserts.
Feb-22-2021 1.57 New document.

Tell us what went wrong