CREATE MATERIALIZED VIEW command to create a materialized view. A materialized view can be created based on sources, tables, materialized views, or indexes.
CREATE MATERIALIZED VIEW [IF NOT EXISTS] mv_name AS select_query;
To perform the operations in the background, you can execute
SET BACKGROUND_DDL=true; before running the
CREATE MATERIALIZED VIEW statement. See details in
|Parameter or clause
|The name of the materialized view to be created.
|A SELECT query that retrieves data for the materialized view. See SELECT for the syntax and examples of the
Names and unquoted identifiers are case-insensitive. Therefore, you must double-quote any of these fields for them to be case-sensitive.
ORDER BY clause in the
CREATE MATERIALIZED VIEW statement is allowed but not considered as part of the definition of the materialized view. It's only used in the initial creation of the materialized view and not during refreshes.
Refer to this tutorial for examples of creating materialized views based on external sources or existing materialized views.