Snowflake Performance: Iceberg Tables, External Tables, and Views

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Understanding the concept of views in Snowflake is vital for creating and querying various types of views. Views allow us to use role-based access control to manage permissions and data security effectively and are essential for organizing and simplifying data and ensuring that only authorized users can access sensitive information. In this course, you will discover how to create and query standard, materialized, and secure views in Snowflake. Then you will configure role-based access control to allow users to access specific views and you will use materialized views to improve the performance of your queries and secure views to control access to the details of the underlying table. Next, you will learn how to query data stored in external cloud locations using Snowflake, integrate Snowflake with Google Cloud Storage buckets, and create an external table to access and query data stored on the Google Cloud using Snowflake. Finally, you will create and configure Iceberg tables in Snowflake for a modern, high-performance format that aids in managing large-scale datasets, providing features like schema evolution, partitioning, and time travel for enhanced data management.