Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

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 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.