Snowflake Architecture

Basicระดับทักษะ

อัปเดตแล้ว 07/2569

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

สร้างบัญชีฟรีของคุณ

ดำเนินการต่อด้วย Google

แสดงตัวเลือกเพิ่มเติม

หรือ

การดำเนินการต่อหมายความว่าคุณยอมรับข้อกำหนดการใช้งาน และนโยบายความเป็นส่วนตัวของเรา รวมถึงการจัดเก็บข้อมูลของคุณในสหรัฐอเมริกา

คำอธิบายคอร์ส

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.

ข้อกำหนดเบื้องต้น

ไม่มีข้อกำหนดเบื้องต้นสำหรับคอร์สนี้

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 XP

Understanding the Architectural Layers

100 XP

Choosing the right edition

50 XP

Ways of Working with Snowflake

50 XP

Running a Query in a Snowflake Notebook

100 XP

Investigating a Failed Query with Query History

100 XP

Snowflake Object Hierarchy

50 XP

Object Hierarchy and Access Control

50 XP

Navigating an Existing Database Structure

100 XP

Parameter Hierarchy

50 XP

Filtering with session variables

100 XP

เริ่มบท

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 XP

Setting up Snowy Peak's database structure

100 XP

Granting the right privileges

50 XP

Virtual Warehouses: Types, Sizing, and Scaling

50 XP

Identifying a misconfigured warehouse

50 XP

Matching workloads to warehouse configurations

100 XP

Solving a concurrency problem

50 XP

Loading Structured and Semi-Structured Data

50 XP

Loading Snowy Peak's user data

100 XP

Querying Snowy Peak's avalanche event data

100 XP

เริ่มบท

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 XP

Partition Pruning

50 XP

Good vs Poor Clustering Key Candidates

100 XP

Impact of reclustering

50 XP

Table Types and Views

50 XP

Table types and data protection

100 XP

Select the correct view type

50 XP

Understanding Materialized Views

50 XP

Working with Unstructured Data

50 XP

Generating a pre-signed URL

100 XP

Pre-signed URL use case

50 XP

เริ่มบท

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 XP

Match Snowflake tools to their use cases

100 XP

Notebook Properties

50 XP

Snowflake Cortex and ML Features

50 XP

Pick the right Cortex function for PDF extraction

50 XP

Snowflake Cortex vs Snowflake ML

100 XP