Snowflake Roadmap 2026
Learn the Snowflake data cloud: architecture, virtual warehouses, loading, querying, security, performance, sharing and cost management.
4 stages · 8 units · Intermediate · about 60 hours · Last reviewed 19 November 2026
What is a snowflake?
Snowflake is a cloud data platform for storing, processing and sharing data using SQL. It separates storage from compute, so independent virtual warehouses can query the same data without interfering with each other. Teams use it for data warehousing, data lakes, pipelines, analytics and secure data sharing across organisations.
Step-by-step snowflake roadmap
- 1
Architecture
Beginner · about 20 hours
How Snowflake works.
- Concepts
Snowflake concepts describe its architecture and core objects. Storage, compute and cloud services are separate layers, with data held in compressed micro-partitions and queries run by virtual warehouses of different sizes. Databases, schemas, tables and warehouses are the objects you create first, and understanding the layers explains Snowflake's cost and scaling behaviour.
- Access
Access in Snowflake is controlled by role-based access control. Privileges on objects are granted to roles, roles are granted to users and to other roles, forming a hierarchy. System roles such as ACCOUNTADMIN, SYSADMIN and SECURITYADMIN have defined duties, and features like network policies and masking policies add further protection.
- Concepts
- 2
Data Loading
Intermediate
Get data in and out.
- Loading
Loading is how data enters Snowflake. Files in cloud storage are referenced through stages, parsed with file formats and copied into tables with COPY INTO, while Snowpipe loads new files continuously. The reverse operation unloads query results back to files. Choosing between bulk and continuous loading depends on latency needs and file arrival patterns.
- Querying
Querying in Snowflake uses standard SQL with extensions for semi-structured data. JSON, Avro and Parquet values are stored in the VARIANT type and read with path notation and functions like FLATTEN. Other features include time travel queries, result caching and common table expressions, which make exploration fast and repeatable.
- Loading
- 3
Transformation
Intermediate
Build pipelines.
- Pipelines
Pipelines in Snowflake are built from streams, tasks and dynamic tables. A stream records row changes on a table, a task runs SQL on a schedule or when triggered, and a dynamic table keeps a query result up to date from a declared target lag. Together they support incremental transformation without an external scheduler.
- Programmability
Programmability is how code runs inside Snowflake. Stored procedures and user-defined functions can be written in SQL, JavaScript, Python or Java, and Snowpark provides a DataFrame API that pushes processing to the warehouse instead of pulling data out. Snowflake also hosts apps, including Streamlit, so logic and interfaces live beside the data.
- Pipelines
- 4
Performance and Governance
Advanced
Run it well.
- Performance
Performance in Snowflake is about running queries quickly at the lowest credit cost. Tuning involves reading the query profile, right-sizing warehouses, using clustering keys on very large tables, avoiding spilling to disk and applying search optimisation where it pays off. Resource monitors help keep spending under control.
- Sharing
Sharing in Snowflake lets one account give another read access to live data without copying it. A provider creates a share containing selected objects, and consumers mount it as a read-only database. Reader accounts serve people without Snowflake, and the Marketplace lists datasets and apps from third parties for discovery and use.
- Performance
Frequently asked questions
Ready to practise for interviews?
Practise snowflake questions with an AI mock interviewer and get feedback on your answers.