Hoppa till huvudinnehåll

course

Snowflake Architecture

GrundläggandeFärdighetsnivå

Uppdaterad 2026-05

Master Snowflake's three-layer architecture and build the mental model you need to work effectively in Snowflake.

Börja Kursen Gratis

Snowflake

3 timmar

13 videos

44 exercises

3,050 XP

Uttalande om prestation

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Älskad av elever på tusentals företag

Training a Team?

Try for Business

Kursbeskrivning

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.

Förkunskapskrav

Det finns inga förkunskapskrav för den här kursen

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 Editions

Understanding the Architectural Layers

Choosing the right edition

Ways of Working with Snowflake

Running a Query in a Snowflake Notebook

Investigating a Failed Query with Query History

Snowflake Object Hierarchy

Object Hierarchy and Access Control

Navigating an Existing Database Structure

Parameter Hierarchy

Filtering with session variables

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.

Creating and Managing Database Objects

Setting up Snowy Peak's database structure

Granting the right privileges

Virtual Warehouses: Types, Sizing, and Scaling

Identifying a misconfigured warehouse

Matching workloads to warehouse configurations

Solving a concurrency problem

Loading Structured and Semi-Structured Data

Loading Snowy Peak's user data

Querying Snowy Peak's avalanche event data

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.

Micro-Partitions and Data Clustering

Partition Pruning

Good vs Poor Clustering Key Candidates

Impact of reclustering

Table Types and Views

Table types and data protection

Select the correct view type

Understanding Materialized Views

Working with Unstructured Data

Generating a pre-signed URL

Pre-signed URL use case

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.

Tools for Every Team

Match Snowflake tools to their use cases

Notebook Properties

Snowflake Cortex and ML Features

Pick the right Cortex function for PDF extraction

Snowflake Cortex vs Snowflake ML

Data Protection and Sharing

Querying historical data with Time Travel

Creating a zero-copy clone

Create and Test a Zero-Copy Clone

Earn your Snowflake University Platform Badge

Congratulations!

Snowflake Architecture

Kursen
är

Få ett prestationsutlåtande

Lägg till denna inloggningsuppgifter i din LinkedIn-profil, ditt CV eller ditt CV
Dela det på sociala medier och i ditt prestationssamtalRegistrera Dig Nu

Gå med över 19 miljoner elever och börja Snowflake Architecture idag!

Skapa ditt gratiskonto

eller

Genom att fortsätta accepterar du våra Användarvillkor, vår Integritetspolicy och att dina uppgifter lagras i USA.

Utveckla dina datakunskaper med DataCamp för mobilen

Gör framsteg när du är på språng med våra mobila kurser och dagliga 5-minuters kodningsutmaningar.