Topolearn

Learn Snowflake

Cloud data warehouse with separate storage and elastic compute

18 lessons · 4 hours · 4 levels · covers Snowflake Snowflake service, 2026 releases

Snowflake is a fully managed cloud data platform that stores data once and lets any number of independent virtual warehouses query it with standard SQL. Data teams use it for analytics, ELT pipelines, semi-structured data and data sharing between organizations. Learning it means learning how warehouses, micro-partitions and roles drive cost, speed and security.

Sign in free to track progressOfficial docs ↗

Before you start

Snowflake builds on these; the tree links to the exact lessons you need.

SQLEssentials level

How deep do you want to go?

1. EssentialsRead and write simple code, do the everyday basics6 lessons · 1 hour in total
2. PracticalUse it productively at work, with the usual idioms11 lessons · 2 hours in total
3. AdvancedThe less common features, performance and trade-offs15 lessons · 3 hours in total
4. ExpertInternals and the edge cases experts know18 lessons · 4 hours in total

The Snowflake tree

SnowflakeSnowflake's architectureSnowflake'sarchitectureVirtual warehouses and creditsVirtual warehousesand creditsDatabases, schemas and contextDatabases, schemasand contextTables and data typesTables and datatypesStages and COPY INTOStages and COPYINTOVARIANT and querying JSONVARIANT andquerying JSONFLATTEN: arrays and nested data to rowsFLATTEN: arrays andnested data to rowsTime Travel, UNDROP and zero-copy cloningTime Travel,UNDROP and zero…Roles and access controlRoles and accesscontrolSnowflake SQL extensions: QUALIFY and friendsSnowflake SQLextensions: QUALIF…Result cache and warehouse cacheResult cache andwarehouse cacheChoosing data typesChoosing data typesJSON columns with jsonbJSON columns withjsonbWindow functionsWindow functions
Essentials and Practical shown (11 of 18 lessons); the full list is below. Click a lesson to read it.

All 18 lessons, in order

Architecture and objects

  1. Snowflake's architecture · Essentials · 8 min

    Storage, compute (virtual warehouses) and cloud services are separate layers that scale independently.

  2. Virtual warehouses and credits · Essentials · 10 min

    Create and size warehouses, use auto-suspend and auto-resume, and understand per-second credit billing.

  3. Databases, schemas and context · Essentials · 8 min

    Navigate the account → database → schema → object hierarchy, set session context with USE, and know how identifiers are case-folded.

  4. Tables and data types · Essentials · 10 min

    Create permanent, transient and temporary tables with Snowflake types like NUMBER, VARCHAR, TIMESTAMP_NTZ/LTZ/TZ and VARIANT.

  5. Time Travel, UNDROP and zero-copy cloning · Practical · 12 min

    Query past versions of data with AT/BEFORE, restore dropped objects with UNDROP, and clone databases instantly without copying data.

Loading data

  1. Stages and COPY INTO · Essentials · 14 min

    Load files in bulk: put them in a stage, describe them with a file format, and load with COPY INTO.

Querying and semi-structured data

  1. VARIANT and querying JSON · Essentials · 12 min

    Store JSON in VARIANT columns and query it with colon and dot paths, bracket access and :: casts.

  2. FLATTEN: arrays and nested data to rows · Practical · 12 min

    Explode arrays and objects into rows with LATERAL FLATTEN, keep empty arrays with OUTER, and flatten recursively.

  3. Snowflake SQL extensions: QUALIFY and friends · Practical · 12 min

    Write tighter queries with QUALIFY, GROUP BY ALL, SELECT * EXCLUDE, IFF, ILIKE, MIN_BY/MAX_BY and the :: cast.

Security and governance

  1. Roles and access control · Practical · 14 min

    Grant privileges to roles, not users; build role hierarchies; and understand system roles, ownership and future grants.

  2. Data governance and secure data sharing · Expert · 16 min

    Protect columns with masking policies and rows with row access policies, and share live data with other accounts without copying it.

Performance and cost

  1. Result cache and warehouse cache · Practical · 10 min

    Understand the persisted result cache, the warehouse local disk cache and metadata-only answers, and when each applies.

  2. Micro-partitions, pruning and clustering · Advanced · 15 min

    See how micro-partition metadata enables pruning, read the query profile, and decide when a clustering key is worth it.

  3. Cost control and warehouse scaling · Expert · 16 min

    Control spend with multi-cluster scaling policies, resource monitors, query acceleration and ACCOUNT_USAGE cost analysis.

  4. Search optimization and materialized views · Expert · 14 min

    Speed up point lookups with search optimization and repeated aggregations with materialized views, and know what each costs.

Pipelines and programmability

  1. Streams, tasks and Snowpipe · Advanced · 16 min

    Track changes with streams, process them on a schedule with tasks and MERGE, and ingest files continuously with Snowpipe.

  2. Dynamic tables · Advanced · 12 min

    Declare a pipeline as a query with a target lag and let Snowflake refresh it incrementally.

  3. UDFs, stored procedures and Snowpark · Advanced · 15 min

    Extend SQL with SQL and Python UDFs, write stored procedures, and use Snowpark DataFrames that run inside Snowflake.