What is a characteristic of materialized views in Snowflake?
What is a characteristic of materialized views in Snowflake?
Materialized views in Snowflake have a limitation that they cannot include joins, including self-joins. This means the underlying query of a materialized view must query only a single table. Therefore, the characteristic of materialized views in Snowflake is that they do not allow joins.
https://docs.snowflake.com/en/user-guide/views-materialized - A materialized view can query only a single table. - Joins, including self-joins, are not supported.
Materialized views can be created on a single table or on multiple tables. The underlying query of a materialized view can contain any valid Snowflake query, including joins, aggregations, and window functions. CREATE MATERIALIZED VIEW my_view AS SELECT customer_id, customer_name, order_id, order_date FROM customers JOIN orders ON customers.customer_id = orders.customer_id; CREATE MATERIALIZED VIEW my_view AS SELECT customer_id, SUM(order_total) AS total_order_amount FROM orders GROUP BY customer_id;
after materialized view is created, it cannot be used to join with any other view / table. rite?
https://docs.snowflake.com/en/user-guide/views-materialized - A materialized view can query only a single table. - Joins, including self-joins, are not supported.
Materialized views don't allow join
https://docs.snowflake.com/en/user-guide/views-materialized
https://docs.snowflake.com/en/user-guide/views-materialized#label-limitations-on-creating-materialized-views
A is correct
Correct
Answer is A The following limitations apply to creating materialized views: A materialized view can query only a single table. Joins, including self-joins, are not supported.