Skip to content
Tutorials Center
My learning

Topics

Snowflake Tutorial

Learn Snowflake step by step: 38 lessons in 9 chapters with examples, quizzes, diagrams and projects.

Start learning →

of lessons completed

Getting Started

  1. 1 What Is Snowflake? Learn what Snowflake is, what problems it solves, how it differs from a classic database, and how this course runs its examples without a Snowflake account.
  2. 2 Accounts, Editions and the Web UI Understand Snowflake accounts, regions, editions and credits, set up a free trial, and find your way around Snowsight, the web interface, plus SnowSQL and drivers.
  3. 3 Your First Queries in Worksheets Write your first Snowflake SQL: create a table, insert rows, select, filter, sort and aggregate. Use sample data, context functions and query history effectively.
  4. 4 Databases, Schemas and Objects Organize Snowflake data with databases and schemas. Compare permanent, transient and temporary tables, views, materialized views, and use SHOW and DESCRIBE.

Architecture

  1. 5 The Three-Layer Architecture Understand Snowflake's three layers: database storage, virtual warehouse compute and cloud services. See how a query flows through them and why they scale independently.
  2. 6 Micro-partitions and Columnar Storage Learn how Snowflake stores tables in micro-partitions, how metadata enables partition pruning, why columnar format is fast, and when clustering keys help.
  3. 7 Virtual Warehouses Create and manage Snowflake virtual warehouses. Learn t-shirt sizes, credits per hour, auto-suspend and auto-resume, and how to pick a size for a workload.
  4. 8 Cloud Services and Metadata Explore the Snowflake cloud services layer: authentication, metadata, the query optimizer, transactions and ACID, free metadata queries and cloud services billing.
  5. 9 Caching Layers Learn Snowflake's three caches: the 24-hour result cache, the warehouse local disk cache and the metadata cache. See when each applies and how to test it.
  6. 10 Time Travel, Fail-safe and Cloning Query and restore past data with Snowflake Time Travel, understand the 7-day Fail-safe, and create zero-copy clones for testing. Includes UNDROP and retention costs.

Loading and Unloading Data

  1. 11 Stages and File Formats Understand internal and external stages, user and table stages, named file formats for CSV, JSON and Parquet, and how to upload and list files before loading.
  2. 12 COPY INTO: Loading a Table Load staged files into a Snowflake table with COPY INTO. Learn load history, FILES and PATTERN, column matching, transformations during load, PURGE and FORCE.
  3. 13 Validating Loads and Handling Errors Find and fix bad rows when loading data into Snowflake. Use VALIDATION_MODE, ON_ERROR options, the VALIDATE function and COPY_HISTORY, plus a quarantine pattern.
  4. 14 Continuous Loading with Snowpipe Learn how Snowpipe loads files automatically as they land in a stage, with auto-ingest from cloud events, the REST API, serverless billing, and Snowpipe Streaming.
  5. 15 Unloading Data with COPY INTO a Location Export Snowflake query results to files with COPY INTO a stage or bucket. Cover CSV, JSON and Parquet output, partitioning, file size, single files and GET.

Querying and Semi-structured Data

  1. 16 SELECT and Snowflake SQL Extras Go beyond standard SQL with Snowflake extras: QUALIFY for window filters, ILIKE, GROUP BY ALL, SELECT EXCLUDE, SAMPLE, MATCH_RECOGNIZE and TRY_ functions.
  2. 17 Semi-structured Data and the VARIANT Type Store JSON, Avro, Parquet and XML in Snowflake with VARIANT, OBJECT and ARRAY. Load JSON, use colon and dot notation, cast values, and understand how it is stored.
  3. 18 FLATTEN and LATERAL Turn JSON arrays and objects into rows with Snowflake FLATTEN and LATERAL. Learn the output columns, OUTER and RECURSIVE options, nested arrays and pivoting back.
  4. 19 Querying JSON: Paths, Arrays and Objects Practical Snowflake JSON querying: GET_PATH, array functions, filtering and aggregating inside VARIANT, JSON null versus SQL NULL, and building views over raw events.

Warehouses and Performance

  1. 20 Virtual Warehouse Sizing and Credits Understand Snowflake virtual warehouses: T-shirt sizes, credits per hour, per-second billing, auto-suspend and auto-resume, and how to pick a size.
  2. 21 Multi-Cluster Warehouses and Concurrency Learn how Snowflake multi-cluster warehouses add clusters for many concurrent users, how scaling policies work, and when queuing means you need scale-out, not size.
  3. 22 The Snowflake Caching Layers Learn the three Snowflake caches: metadata, the 24-hour result cache and the warehouse SSD cache. See when each is used, what invalidates it and how to test it.
  4. 23 Micro-Partition Pruning and the Query Profile Learn how Snowflake micro-partitions and min/max metadata let queries skip data, and how to read the Query Profile to find scans, spilling and bad joins.
  5. 24 Clustering Keys and Automatic Clustering Learn when to define a Snowflake clustering key, how clustering depth and overlap are measured, how automatic clustering costs credits, and how to choose columns.
  6. 25 Search Optimization, Materialized Views and Query Acceleration Compare Snowflake's search optimization service, materialized views and query acceleration service: what each speeds up, what it costs and when to choose it.

Security and Governance

  1. 26 Roles, Privileges and Access Control Learn Snowflake role-based access control: system roles, the role hierarchy, GRANT and REVOKE, future grants, database roles and a least-privilege design.
  2. 27 Authentication, MFA and Network Policies Secure access to Snowflake: password and MFA, SSO, key-pair authentication, service users, tokens, SCIM and network policies that allow or block IP ranges.
  3. 28 Dynamic Data Masking and Row Access Policies Protect sensitive data in Snowflake with dynamic data masking, row access policies, tags and classification so different roles see different values from one table.
  4. 29 Secure Views, Secure Data Sharing and Governance Learn secure views, secure data sharing with shares and reader accounts, the Marketplace, and governance tools: access history, object tags and data lineage.

Streams, Tasks and Pipelines

  1. 30 Streams and Change Data Capture Learn Snowflake streams: how they track inserts, updates and deletes with METADATA columns, standard versus append-only streams, offsets and consuming changes.
  2. 31 Tasks and Task Graphs Learn Snowflake tasks: schedules and cron, WHEN conditions with streams, task graphs (DAGs) with AFTER, serverless tasks, resuming, monitoring and error handling.
  3. 32 Dynamic Tables and Declarative Pipelines Learn Snowflake dynamic tables: declare a query and a target lag, let Snowflake refresh incrementally, chain tables into pipelines and compare them to streams and tasks.
  4. 33 Designing an ELT Pipeline in Snowflake Design a Snowflake ELT pipeline with raw, clean and mart layers, idempotent MERGE loads, data quality checks, error handling and a choice between tasks and dynamic tables.

Snowpark and Cost

  1. 34 Snowpark DataFrames in Python Learn Snowpark for Python: sessions, lazy DataFrames that push work down to Snowflake SQL, col and functions, joins, aggregation, writing tables and when to use pandas.
  2. 35 UDFs, UDTFs and Stored Procedures Write Snowflake user-defined functions in SQL and Python, table functions, vectorized UDFs, stored procedures with Snowflake Scripting and Python, and learn when to use each.
  3. 36 Cost Monitoring and Resource Monitors Understand Snowflake billing for compute, storage and serverless features, find the expensive warehouses and queries, and set resource monitors and budgets that cap spend.

Projects and Practice

  1. 37 Project: A Retail Analytics Pipeline Build a retail analytics pipeline step by step: raw tables, cleaning, dimensions and facts, a change feed, KPI queries and a Snowflake deployment plan with roles and cost controls.
  2. 38 Practice: SQL Challenges and Snowflake Interview Questions Practice analytics SQL with window functions, deduplication, gaps and cohorts, then review Snowflake interview questions on warehouses, caching, clustering, streams and cost.