How to Create a Materialized View in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use CREATE MATERIALIZED VIEW ... AS SELECT to store the query result physically. Refresh it on demand with REFRESH MATERIALIZED VIEW, or add AUTO REFRESH YES to let Redshift refresh it as base tables change.
CREATE MATERIALIZED VIEW daily_revenue
AUTO REFRESH YES
AS
SELECT created_at::date AS day, SUM(amount) AS revenue
FROM orders
GROUP BY 1;Manual refresh
REFRESH MATERIALIZED VIEW daily_revenue;Redshift refreshes incrementally when the defining query allows it (no outer joins, certain aggregates only); otherwise a refresh recomputes the full result. Check SVV_MV_INFO to see whether a view is stale.
Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free