Creating materialized views

You can create a materialized view based on one or more of the following:

• Amazon Redshift tables

• External tables that you can create by using Amazon Redshift Spectrum or a federated query

• Other materialized views

When you create a materialized view, Amazon Redshift runs the user-specified SQL statement to gather the data from the base table or tables. Then, Amazon Redshift stores the result set.

The following illustration provides an overview of a materialized view called mv_total_orders. This view is defined by a SQL query that uses two base tables: customer and order.