Posts

Showing posts with the label Snowflake Views

Snowflake Views | Types of views in Snowflake | Materialized Views | Secure Views

  Hello Data Pros, and welcome back to another exciting episode of our Snowflake learning series! In our previous video, we explored advanced table types, with easy-to-follow examples along the way. Today, we'll take a step forward to understand the different types of views in Snowflake, along with their use cases and practical examples! Just like tables and stages, views are also database objects, that allow the result of a SELECT query to be accessed as if it were a table. The SELECT query is specified in the CREATE VIEW DDL statement. It's worth noting that we cannot perform any DML operations such as insert, update, and delete directly on views. However, any DML operations performed on the underlying tables are always reflected in the views. --                  Views LAB - Non-materialized views, Materialized views, Secure Views                 -- --             ...