Snowflake Data Engineering Training

Chapter 1: Snowflake Architecture & Features

· What is Snowflake

· Snowflake Architecture

· Storage Layer Overview

· Query Processing Layer Overview

· Services Layer Overview

· Snowflake Editions

· Warehouse, Role, Database, Schema

· Table & Types of Tables

· Views & Types of Views

· Databases, Schemas, Tables & Views - Hands-on

· Billing Overview

· Snow SQL - Hands-on

Chapter 2: Performance Concepts & Virtual Warehouse

1. Virtual Warehouse Overview
2. Virtual Warehouse Sizing and Billing
3. Resource Monitors
4. Compute Monitoring & Resource Monitors - Hands-on
5. Multi-cluster Warehouses

Chapter 3: Performance Concepts & Query Optimization

1. Caching & Types
2. Materialized Views
3. Clustering
4. Zero Copy Cloning
5. Query Profile & History

Chapter 4: Data Loading and Unloading

· File Formats

· Stages – External Stages, Internal Stages

1. Bulk Loading - COPY INTO TABLE command
2. Basics of Snow Pipe
3. Data Unloading

Chapter 5: Storage Layer, Data Protection

1. Storage Layer Overview
2. Micro-partitions
3. Time Travel & Fail-Safe