How Snowflake serves queries
Pause
FOR CONTEXT
How query-ready data enables fast answers
Fresh-data path
Newly
written
Fresh
data
continuously
Query-ready data
Ordered
raw data
Ordered pre-
aggregated
Query engine
Query
compute
Fast
answers
continuously
Drill-downs
Interactive aggs
Snowflake
Fresh-data path
Snowpipe
Streaming
High-performance
architecture
NBBO
quotes
1M rows/s
Interactive table
Ordered
raw data
Interactive MV
Ordered pre-
aggregated
Async
serverless
MV refresh
Fallback
warehouse
Gen 2 · Small · 16 CPUs
Interactive
warehouse
Small · 16 CPUs
600 GB cache
Prune
ordered data
Delta
since
MV refresh
Catch up
on read
Query
results