How Redshift Serverless 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
Redshift
Fresh-data path
Query-ready data
1
Producer
Workgroup
Streaming
ingestion
32 RPUs
Streaming MV
Ordered
raw data
Aggregate MV
Ordered pre-
aggregated
NBBO
quotes
1M rows/s
AMAZON
MSK
2
3
Background
sorting
Continuous
best-effort
refresh
Consumer
Workgroup
32 RPUs
Query
results
4 interactive aggs
every 10 min
2 drill-downs
every hour