A materialized view on an external table precomputes the query logic and stores the results in Snowflake, avoiding repeated scans of external files:
Faster Repeated Queries: Subsequent queries read from the view’s stored data rather than re‑scanning files
Metadata Synchronization: Ensure the external table’s metadata is refreshed so the view includes all new or updated files
Note: Materialized views over external tables require Enterprise Edition.
To improve query performance, you can use a materialized view based on an external table. This sentence is from https://docs.snowflake.com/en/user-guide/tables-external-intro. Hence, the reply is B.
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.
Billhardy
1 week, 6 days ago37ceea2
3 months ago