Intermediate

Snowflake — Zero to Advanced

A real Snowflake track: warehouse fundamentals, architecture, SQL, loading, ELT, governance, performance, cost, dbt, operations, and system design.

Snowflake cheat sheet and project ideas →

Est. Self-paced September 2026
Beginners
Starts from what a warehouse is and why Snowflake exists.
Data engineers
Covers loading, MERGE, ELT, tasks, monitoring, and operations.
Analytics engineers
Covers marts, dbt, testing, governance, and cost.
Interview prep
Builds senior-level Snowflake explanation and design language.
22
Planned lessons
22
Deep lessons live now
5
Sections
111+
Concepts covered
0
Prerequisites
This is a full Snowflake track, not a single article. Every module has a live lesson: plain-English explanation, SQL examples, production mistakes, cost and security notes, and interview framing.
// Curriculum

22 Lessons. Snowflake from First Query to Production Platform.

Follow in order. Each module starts from the beginner mental model and ends with production and interview readiness.

1
Section 1 — Snowflake Foundations
MODULE 01LIVE

What is Snowflake?

Snowflake explained from scratch: warehouse vs database, OLAP vs OLTP, and why companies use it.

WarehouseOLAPStorageComputeAnalytics
55 min
Beginner
Start →
MODULE 02LIVE

Snowflake Architecture

Storage, virtual warehouses, cloud services, micro-partitions, metadata, caching, and scaling.

StorageVirtual warehousesCloud servicesMicro-partitionsCache
65 min
Beginner
Start →
MODULE 03LIVE

Setup and SQL Basics

Create warehouses, databases, schemas, tables, roles, and run the SQL every beginner needs.

WarehouseDatabaseSchemaTableRoleSQL
70 min
Beginner
Start →
MODULE 04LIVE

Roles and Security Basics

RBAC, grants, ownership, least privilege, users, roles, future grants, and common access mistakes.

RBACGrantsOwnershipUsersFuture grants
60 min
Beginner
Start →
2
Section 2 — Loading and Transforming Data
MODULE 05LIVE

Loading Data with Stages and COPY INTO

Internal stages, external stages, file formats, COPY INTO, validation, rejected rows, and load history.

StagesFile formatsCOPY INTOLoad historyValidation
75 min
Intermediate
Start →
MODULE 06LIVE

Semi-Structured Data: VARIANT, JSON, FLATTEN

Load and query JSON, arrays, nested fields, VARIANT, OBJECT, ARRAY, and LATERAL FLATTEN.

VARIANTJSONFLATTENOBJECTARRAY
70 min
Intermediate
Start →
MODULE 07LIVE

ELT and Medallion Architecture in Snowflake

Raw, Silver, Gold, dimensional marts, dbt models, tests, and production-grade transformation patterns.

ELTRawSilverGolddbtMarts
80 min
Intermediate
Start →
MODULE 08LIVE

MERGE, Upserts, and Idempotent Pipelines

MERGE syntax, staging tables, deduplication, reruns, watermarks, and exactly-once-style pipeline design.

MERGEUpsertIdempotencyWatermarkDeduplication
75 min
Intermediate
Start →
3
Section 3 — Snowflake Platform Features
MODULE 09LIVE

Time Travel, Fail-safe, and Zero-Copy Cloning

Recover data, debug mistakes, clone environments, and understand retention and storage implications.

Time TravelFail-safeCloneRecoveryRetention
65 min
Intermediate
Start →
MODULE 10LIVE

Snowpipe and Continuous Loading

Snowpipe architecture, auto-ingest, cloud notifications, latency, errors, and when not to use it.

SnowpipeAuto-ingestNotificationsLatencyErrors
70 min
Intermediate
Start →
MODULE 11LIVE

Streams and Tasks

Change tracking, scheduled SQL, task graphs, incremental ELT, serverless tasks, and production pitfalls.

StreamsTasksCDCTask graphIncremental
80 min
Advanced
Start →
MODULE 12LIVE

Dynamic Tables

Declarative incremental pipelines, target lag, refresh modes, comparison with streams/tasks and materialized views.

Dynamic tablesTarget lagRefreshIncremental
65 min
Advanced
Start →
4
Section 4 — Performance, Cost, and Governance
MODULE 13LIVE

Performance Tuning

Micro-partition pruning, clustering, search optimization, query profile, caching, and warehouse sizing.

PruningClusteringQuery profileCacheWarehouse sizing
85 min
Advanced
Start →
MODULE 14LIVE

Cost Optimization

Credits, warehouses, auto-suspend, query waste, resource monitors, chargeback, budgets, and query history.

CreditsAuto-suspendResource monitorsChargebackQuery history
75 min
Advanced
Start →
MODULE 15LIVE

Advanced Security and Governance

Masking policies, row access policies, object tagging, classification, access history, and auditing.

MaskingRow accessTagsClassificationAudit
80 min
Advanced
Start →
MODULE 16LIVE

Data Sharing and Marketplace

Secure data sharing, reader accounts, listings, clean rooms, and cross-organization governance.

Data sharingMarketplaceReader accountsClean rooms
60 min
Advanced
Start →
5
Section 5 — Production and Career Readiness
MODULE 17LIVE

Snowflake with dbt

dbt project structure, sources, models, tests, snapshots, incremental models, environments, and CI/CD.

dbtModelsTestsSnapshotsCI/CD
85 min
Advanced
Start →
MODULE 18LIVE

Snowpark for Python

Build Python DataFrame transformations that execute in Snowflake, persist results safely, and choose between Snowpark jobs, UDFs, stored procedures, SQL, and dbt.

Snowpark PythonDataFramesLazy executionStored proceduresUDFsTesting
35-45 min
Advanced
Start →
MODULE 19LIVE

Snowflake Cortex AI Functions

Use Cortex AI SQL functions for classification, sentiment, summarization, and completion with evaluation, privacy, access, and cost controls.

Cortex AIAI_CLASSIFYAI_SENTIMENTAI_SUMMARIZEAI_COMPLETEEvaluation
35-45 min
Advanced
Start →
MODULE 20LIVE

Production Operations and Monitoring

Account usage views, load/query/task history, alerts, incident response, runbooks, and SLAs.

MonitoringAccount usageAlertsRunbooksSLA
75 min
Advanced
Start →
MODULE 21LIVE

End-to-End Snowflake Project

Build a full orders analytics platform: ingest, clean, merge, test, model, secure, optimize, and monitor.

ProjectOrdersPipelineMartsMonitoring
120 min
Advanced
Start →
MODULE 22LIVE

Snowflake Interview and System Design

Interview answers, architecture tradeoffs, cost scenarios, incident debugging, and senior-level design prompts.

InterviewSystem designTradeoffsIncidents
90 min
Advanced
Start →
Share

Discussion

0

Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.

Continue with GitHub
Loading...