Snowflake Data Warehousing: The Complete Guide
Master Snowflake data warehousing from setup to advanced features, optimizing performance, security, and cost for real-world applications.
...
Share
Introduction to Snowflake and Data Warehousing Fundamentals
Unit 1: Data Warehousing Fundamentals
What is Data Warehousing?
Benefits in the Cloud Era
Data Warehouse Use Cases
Limitations of Traditional DW
The Rise of Cloud DW
Unit 2: Snowflake's Architecture and Features
Snowflake: An Overview
Shared Data Architecture
Compute Layer
Storage Layer
Cloud Services Layer
Unit 3: Initial Setup and Configuration
Creating a Snowflake Account
Navigating the UI
SnowSQL: CLI Access
Security Configuration
Warehouse Configuration
Data Ingestion, Modeling, and Transformation in Snowflake
Unit 1: Data Loading Techniques: Bulk Loading
Intro to Bulk Loading
Setting Up Your Stage
The COPY Command
Transforming During Load
Bulk Loading Gotchas
Unit 2: Data Loading Techniques: Snowpipe
Snowpipe Intro
Setting Up Snowpipe
Snowflake's Event Tables
Snowpipe Transformations
Snowpipe Security
Unit 3: Data Modeling Fundamentals
Data Modeling Intro
Star Schema
Snowflake Schema
Data Vault Modeling
Choosing Your Model
Unit 4: Data Transformation Strategies
Transformation Intro
Using Snowflake SQL
External Functions
dbt for Transformation
Testing & Validation
SQL, Performance Optimization, and Cost Management
Unit 1: SQL Essentials in Snowflake
Selecting Like a Pro
Joins: Data Unifiers
Aggregating Data
Inserting Is a Breeze
Common Table Expressions
Unit 2: Snowflake-Specific SQL Functions
Variant Data Handling
Date & Time Gymnastics
String Manipulation
Window Wonderland
Secure Data Sharing
Unit 3: Performance Tuning
Profiling Queries
Clustering Keys
Virtual Warehouse Sizing
Materialized Views
Data Partitioning
Unit 4: Cost Management
Understanding Credits
Warehouse Monitoring
Query Optimization
Resource Monitors
Storage Cost Control
Advanced Features, Security, and Data Governance
Unit 1: Snowflake's Time Travel and Fail-safe
Time Travel Overview
Using Time Travel
Fail-safe Deep Dive
Time Travel Configuration
TT Gotchas & Limitations
Unit 2: Materialized Views in Snowflake
MV: The Basics
Creating MVs
MV Under the Hood
MV Restrictions
MV Use Cases
Unit 3: Security and Access Control
Securing Snowflake
Role-Based Access
Network Policies
Data Encryption
MFA
Unit 4: Data Governance and Auditing
Data Governance
Data Classification
Data Masking
Auditing in Snowflake
Compliance
Unit 5: Data Sharing and Marketplace
Secure Data Sharing
Sharing Internally
Sharing Externally
Data Marketplace
Listing on Marketplace
Snowflake Integrations, Latest Trends, and Best Practices
Unit 1: Integrating Snowflake with ETL/ELT Tools
ETL/ELT Intro
Fivetran Deep Dive
Matillion Overview
dbt and Snowflake
Custom ETL/ELT
Unit 2: Connecting Snowflake to Data Visualization Tools
Viz Tool Intro
Tableau Integration
Power BI Connection
Looker and Snowflake
Other Viz Tools
Unit 3: Latest Snowflake Trends and Updates
Snowpark Overview
Unistore Explained
Dynamic Tables Intro
External Functions
What's Coming Next?
Unit 4: Snowflake Data Warehousing Best Practices
Perf Best Practices
Security Best Practices
Cost Best Practices
Governance
Community & Support