Deliver data to CockroachDB
CockroachDB is a distributed database with standard SQL for cloud applications.
Quick Start
Connect in minutes with SQL
Use CREATE SINK to deliver processed data from RisingWave to CockroachDB. Define your transformation logic in SQL and let RisingWave handle delivery, retries, and exactly-once semantics.
CREATE SINK cockroachdb_sink 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 = 'jdbc',
jdbc.url = 'jdbc:postgresql://cockroachdb:26257/defaultdb?user=root',
table.name = 'target_count',
type = 'upsert',
primary_key = 'target_id'
);For comprehensive configuration details, please refer to the CockroachDB connector documentation.
Capabilities
What you can do with RisingWave + CockroachDB
Continuous Delivery
Automatically sink processed results from RisingWave to CockroachDB as new data arrives. No batch jobs needed.
Exactly-once Semantics
Guaranteed data correctness when delivering to CockroachDB with barrier-based checkpointing.
Upsert & Append
Support both append-only and upsert modes when sinking to CockroachDB, depending on your use case.
Sink Decoupling
Built-in buffering ensures RisingWave stays stable even if CockroachDB experiences temporary slowdowns.
Start streaming in minutes
Connect to CockroachDB with just a few lines of SQL. No infrastructure to manage, no code to write.
