Deliver data to Google BigQuery
BigQuery is a managed, serverless data warehouse product by Google, offering scalable analysis over large quantities of data.
Quick Start
Connect in minutes with SQL
Use CREATE SINK to deliver processed data from RisingWave to Google BigQuery. Define your transformation logic in SQL and let RisingWave handle delivery, retries, and exactly-once semantics.
CREATE SINK big_query_sink_local AS
SELECT
order_status,
COUNT(*) as order_count,
SUM(total_amount) as total_revenue,
AVG(total_amount) as avg_order_value,
MIN(last_updated) as first_order_time,
MAX(last_updated) as last_order_time
FROM orders_rw
WITH (
connector = 'bigquery',
type = 'append-only',
bigquery.local.path = '/path/to/my/service-account.json',
bigquery.project = 'my_project_id',
bigquery.dataset = 'my_dataset',
bigquery.table = 'my_table',
force_append_only = 'true'
);For comprehensive configuration details, please refer to the BigQuery connector documentation.
Capabilities
What you can do with RisingWave + Google BigQuery
Continuous Delivery
Automatically sink processed results from RisingWave to Google BigQuery as new data arrives. No batch jobs needed.
Exactly-once Semantics
Guaranteed data correctness when delivering to Google BigQuery with barrier-based checkpointing.
Upsert & Append
Support both append-only and upsert modes when sinking to Google BigQuery, depending on your use case.
Sink Decoupling
Built-in buffering ensures RisingWave stays stable even if Google BigQuery experiences temporary slowdowns.
Resources
Learn more
Start streaming in minutes
Connect to Google BigQuery with just a few lines of SQL. No infrastructure to manage, no code to write.
