Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics (2022)
2h 9mAdvanced2022-09-06
Authors
Janani Ravi
Certified Google Cloud Architect and Data Engineer
Course details
If you’re familiar with the Snowflake platform but need to learn more, this course can help you supercharge your skills. Instructor Janani Ravi deep dives into architecture and advanced concepts. After a concise introduction, Janani gets started with table structures in Snowflake, covering topics like micropartitioning, clustering, and creating permanent, temporary, and transient tables. She explains views in Snowflake, then demonstrates several useful techniques for optimizing query performance. Janani goes over working with semi-structured data, including loading and querying parquet data and JSON data. Plus, she shows you how to articulate the access control system in Snowflake, create users, view grants, and grant privileges to roles.
Skills covered
SnowflakeCloud StorageAdvancedDatabase DevelopmentDatabase ManagementCloud ServicesCloud ComputingSoftware Development
Concepts
Introduction
- Advanced Snowflake
- Snowflake architecture
- Getting set up with Snowflake
Table Structures in Snowflake
- Micropartitioning and clustering
- Types of tables in Snowflake
- Creating permanent tables
- Creating temporary tables
- Creating transient tables
- Configuring data retention time
- Querying historical data
- Dropping and restoring tables
Views in Snowflake
- Non-materialized, materialized, and secure views
- Creating and populating tables
- Creating and querying views
- Recreating views
- Querying regular views and secure views
- Creating and querying materialized views
Optimizing Query Performance
- Caching, clustering, and search optimization
- Loading data using COPY INTO
- Retrieval optimization using cached results
- Enabling clustering on tables
- Querying clustered tables
- Querying clustering information
- Running point lookup queries on search-optimized tables
- Clustering vs. search optimization
Working with Semi-structured Data
- Loading and querying parquet data
- Loading JSON data
- Querying JSON data
Managing Users and Granting Privileges
- Access control
- Creating users and viewing grants
- Granting privileges to roles
Conclusion
- Summary and next steps