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;
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.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
vinny2020
Highly Voted 1 year, 4 months agomickies9
Most Recent 7 months, 2 weeks agoKarthyJay
10 months, 1 week ago[Removed]
1 year, 1 month agoHeetec
1 year, 2 months agoJG1984
1 year, 3 months agosubhataanu
6 months, 1 week agovinny2020
1 year, 4 months agoMultiCloudIronMan
1 year, 5 months agohappykeieiekek
1 year, 5 months ago