Deliver data to ClickHouse
A high-performance, column-oriented SQL database management system (DBMS) for online analytical processing (OLAP).
Quick Start
Connect in minutes with SQL
Use CREATE SINK to deliver processed data from RisingWave to ClickHouse. Define your transformation logic in SQL and let RisingWave handle delivery, retries, and exactly-once semantics.
CREATE SINK clickhouse_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 = 'clickhouse',
type = 'append-only',
clickhouse.url = 'clickhouse://localhost:8123',
clickhouse.user = 'clickhouse_demo',
clickhouse.password = 'demoPass123!',
clickhouse.database = 'default',
clickhouse.table='demo_test'
);For comprehensive configuration details, please refer to the ClickHouse connector documentation.
Capabilities
What you can do with RisingWave + ClickHouse
Continuous Delivery
Automatically sink processed results from RisingWave to ClickHouse as new data arrives. No batch jobs needed.
Exactly-once Semantics
Guaranteed data correctness when delivering to ClickHouse with barrier-based checkpointing.
Upsert & Append
Support both append-only and upsert modes when sinking to ClickHouse, depending on your use case.
Sink Decoupling
Built-in buffering ensures RisingWave stays stable even if ClickHouse experiences temporary slowdowns.
Start streaming in minutes
Connect to ClickHouse with just a few lines of SQL. No infrastructure to manage, no code to write.
