After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
Get a complete picture of how Snowflake is built and why it works the way it does. Starting from the three-layer architecture that separates compute, storage, and cloud services, you'll work your way through virtual warehouses, storage internals, and Snowflake's AI/ML capabilities. By the end, you'll have the foundational mental model needed to work effectively in Snowflake.
Prerequisites
There are no prerequisites for this course
Curriculum
Course outline
1
How Snowflake Works
Get oriented with Snowflake's core architecture — how its three-layer design separates compute, storage, and services to enable massive scalability. You'll explore the Snowsight interface and learn how every object in Snowflake fits into a structured hierarchy.
- Snowflake Architecture and Editions50 XP
- Understanding the Architectural Layers100 XP
- Choosing the right edition50 XP
- Ways of Working with Snowflake50 XP
- Running your first Query100 XP
- Investigating a Failed Query with Query History100 XP
- Snowflake Object Hierarchy50 XP
- Object Hierarchy and Access Control50 XP
- Navigating an Existing Database Structure100 XP
- Parameter Hierarchy50 XP
- Filtering with session variables100 XP
2
Virtual Warehouses and Loading Data
Learn how to create and configure the objects that power your Snowflake environment. You'll size and tune virtual warehouses for different workloads, then get hands-on with loading both structured and semi-structured data into tables.
3
Micro-Partitions and Data Clustering
Go under the hood to see how Snowflake physically organizes data using micro-partitions and clustering keys. You'll also compare table types and views to understand when to use each, and explore how Snowflake handles unstructured files alongside traditional data.
4
AI/ML, Data Protection, and Sharing
Round out your Snowflake foundation by exploring its growing AI/ML ecosystem — from Snowpark and Cortex to Streamlit and Notebooks. You'll also cover essential data protection techniques like Time Travel and cloning, and see how the Snowflake Marketplace enables easy data sharing.
S
Snowflake Architecture
Course
Complete
