How BigQuery 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
BigQuery
Fresh-data path
Storage Write
API streams
Committed
streams
NBBO
quotes
1M rows/s
Clustered table
Incremental MV
Ordered
raw data
Ordered pre-
aggregated
Async
serverless
clustering
Async
serverless
MV refresh
Serverless
compute pool
Dynamic slots
Query
results
4 interactive aggs
every 10 min
2 drill-downs
every hour
May scan
unordered data
Delta
since
MV refresh
Catch up
on read