BigQuery Stream (All Events)

BigQuery Stream (All Events) has been made generally available across all RudderStack plans. This destination streams all event types to BigQuery almost instantly via the BigQuery Storage Write API. It maintains the warehouse schema for tables, just like the batch BigQuery destination. Previously, the BigQuery Stream integration only inserted track events into a pre-created table, as the destination didn't generate or modify the schema.

Properties of each track event were mapped to specific columns in the table since the destination only read from it. Loading all other event types into the standard warehouse tables required using the batch BigQuery destination and patiently waiting for each synchronization. The new BigQuery Stream (All Events) removes this trade-off by streaming every event type in near real time.

It leverages BigQuery's more cost-effective Storage Write API to manage tables with the same warehouse schema as the batch destination. The full documentation for BigQuery Stream (All Events) outlines the prerequisites and provides detailed setup instructions.