Views can be created against external tables.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Views can be created against external tables.

Explanation:
In Snowflake, a view is a saved query definition, and it can reference any table, including external tables. An external table maps to data stored outside Snowflake (for example, in S3) via a stage and a file format, but it behaves like a table in queries. So you can create a view that selects from an external table, and when you query that view, Snowflake reads the data from the external location through the external table’s metadata. The view itself doesn’t store data—it simply defines how to present the data from the external source. This makes it convenient to present a clean, stable schema to users while the actual data remains in external storage. There’s no special license required for this capability, it’s a standard feature.

In Snowflake, a view is a saved query definition, and it can reference any table, including external tables. An external table maps to data stored outside Snowflake (for example, in S3) via a stage and a file format, but it behaves like a table in queries. So you can create a view that selects from an external table, and when you query that view, Snowflake reads the data from the external location through the external table’s metadata. The view itself doesn’t store data—it simply defines how to present the data from the external source. This makes it convenient to present a clean, stable schema to users while the actual data remains in external storage. There’s no special license required for this capability, it’s a standard feature.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy