Pre-aggregation lag

FOR CONTEXTPre-aggregation lag depends on how the data is kept freshFresh-data pathQuery-ready dataNewlywrittenOrderedraw dataOrdered pre-aggregatedFreshdatacontinuouslyQuery engineQuerycomputeFastanswerscontinuouslyPOSSIBLE LAG
Drag to explore0.0B / 100B

Lag between raw data and pre-aggregated data

Published Part 2 freshness display curve. ClickHouse’s zero baseline represents synchronous incremental materialized-view maintenance. Snowflake refreshes its serverless materialized view asynchronously.