How ClickHouse Cloud prepares incoming data
Pause
FOR CONTEXT
How real-time systems keep incoming data query-ready
Fresh-data path
Query-ready data
Newly
written
Ordered
raw data
Ordered pre-
aggregated
Query engine
Query
compute
Fresh
data
continuously
Fast
answers
continuously
1
Store in
columns
2
Order
data
3
Order and pre-
aggregate data
ClickHouse Cloud
Fresh-data path
Query-ready data
1
2
3
Ingest
service
2 nodes
2 CPUs / 8 GiB each
MergeTree table
Ordered
raw data
Incremental MV
Ordered pre-
aggregated
Always in sync
Read service
1 node
16 CPUs / 64 GiB
Query
results
NBBO
quotes
1M rows/s