首页 Snowflake

课程

Snowflake Architecture

基础技能水平

更新时间 2026年5月

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

免费开始课程

Snowflake

3 小时

13 视频

44 练习

3,050 经验值

成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

Training a Team?

Try for Business

课程描述

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.

先决条件

本课程无先修要求

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

50 经验值

Understanding the Architectural Layers

100 经验值

Choosing the right edition

50 经验值

Ways of Working with Snowflake

50 经验值

Running a Query in a Snowflake Notebook

100 经验值

Investigating a Failed Query with Query History

100 经验值

Snowflake Object Hierarchy

50 经验值

Object Hierarchy and Access Control

50 经验值

Navigating an Existing Database Structure

100 经验值

Parameter Hierarchy

50 经验值

Filtering with session variables

100 经验值

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

50 经验值

Setting up Snowy Peak's database structure

100 经验值

Granting the right privileges

50 经验值

Virtual Warehouses: Types, Sizing, and Scaling

50 经验值

Identifying a misconfigured warehouse

50 经验值

Matching workloads to warehouse configurations

100 经验值

Solving a concurrency problem

50 经验值

Loading Structured and Semi-Structured Data

50 经验值

Loading Snowy Peak's user data

100 经验值

Querying Snowy Peak's avalanche event data

100 经验值

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

50 经验值

Partition Pruning

50 经验值

Good vs Poor Clustering Key Candidates

100 经验值

Impact of reclustering

50 经验值

Table Types and Views

50 经验值

Table types and data protection

100 经验值

Select the correct view type

50 经验值

Understanding Materialized Views

50 经验值

Working with Unstructured Data

50 经验值

Generating a pre-signed URL

100 经验值

Pre-signed URL use case

50 经验值

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

50 经验值

Match Snowflake tools to their use cases

100 经验值

Notebook Properties

50 经验值

Snowflake Cortex and ML Features

50 经验值

Pick the right Cortex function for PDF extraction

50 经验值

Snowflake Cortex vs Snowflake ML

100 经验值

Data Protection and Sharing

50 经验值

Querying historical data with Time Travel

100 经验值

Creating a zero-copy clone

100 经验值

Create and Test a Zero-Copy Clone

100 经验值

Earn your Snowflake University Platform Badge

50 经验值

Congratulations!

50 经验值

Snowflake Architecture

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Snowflake Architecture！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。