From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Views in Snowflake

Views in Snowflake - Snowflake Tutorial

From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Start my 1-month free trial Buy for my team

Views in Snowflake

“

If you analyze data using the same complex query over and over again, it might be useful for you to define a view. Views in Snowflake are defined by a query, and views allow users to access the result of that query as though the result were in a table. Views can thus be thought of as a named reference to a query. And other queries can reference views exactly like they do tables. Just like you use a table name within a query, you can use a view name instead. Views are very useful because they give you access to different cuts of your data. Views allow you to combine, segregate, or protect data. For example, instead of giving users access to all of the records in a table, you might want to give them access to only a subset of records that you define using a view. Snowflake supports several different types of views. When you say view, what we are referencing is a standard view, which is just a stored SQL query that executes every time you reference it. The view itself does not store any…

Contents