Advanced SnowflakeDB

Advanced Snowflake Deep Dive Cloud Data Warehousing and Analytics

If you’re familiar with the Snowflake platform but need to learn more, this course can help you supercharge your skills. Instructor deep dives into architecture and advanced concepts. After a concise introduction, Instructor gets started with table structures in Snowflake, covering topics like micro-partitioning, clustering, and creating permanent, temporary, and transient tables. She explains views in Snowflake, then demonstrates several useful techniques for optimizing query performance. Instructor 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.