A materialized view is a precomputed dataset derived from a query specification (the SELECT in the view definition) and stored internally in Snowflake storage for later use. Because the data is precomputed, querying a materialized view is faster than running a query against the base table of the view. The materialized view is automatically synched with the underlying data in ECS when the external table is refreshed. For more information, see Materialized Views over External Tables in the Snowflake documentation.
This example creates a materialized view on the sepal_length and petal_length where the petal_length is less than 5:
create or replace materialized view iris_mv as
select sepal_length, petal_length from ext_table_dellecs where sepal_length < 5;
Now, when we query the iris_mv view, the results will include only data from the specified SQL select statement.
