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.
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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, 3 months agomickies9
Most Recent 6 months, 2 weeks agoKarthyJay
9 months, 1 week ago[Removed]
1 year, 1 month agoHeetec
1 year, 1 month agoJG1984
1 year, 2 months agosubhataanu
5 months, 2 weeks agovinny2020
1 year, 3 months agoMultiCloudIronMan
1 year, 4 months agohappykeieiekek
1 year, 4 months ago