Snowflake Course Content
1. Introduction to Cloud
• What is Cloud?
• Different Cloud Vendors Advantages of
• Cloud over On-Premise
2. Data Warehousing Concepts
What is a Data Warehouse?
Database vs Data Warehouse Why do
we need a Data Warehouse? OLTP vs
OLAP What is ETL?
3. Introduction to Snowflake
• Supported Cloud Platforms
•
Snowflake Architecture
o Cloud Service Layer
o Compute/Query Processing Layer
o Storage Layer
• Snowflake Editions
• Setting up Virtual Warehouses
• Scaling Policy
4. Connecting to Snowflake
• User Interface
• SnowSQL (CLI Client)
• Using Python Using
• 3rd Party Tools
5. Data Loading and Unloading in Snowflake
• Supported File Formats
• Creating File Formats
• Types of Data Loading
o Limited Data
www.survitechnologies.com 90000 12244
o Bulk Data
o Continuous Data
• Data Loading/Unloading Methods
o Web Interface
o Local File
o Amazon S3
o Microsoft Azure
o Google Cloud
• Creating Stage & Raw File
• Parsing JSON Handling
• Nested Data Dealing with
• Hierarchy Loading
• PARQUET Data
• Insert Final Data
6. Working with Semi-Structured Data
7. Stages
• What is a Stage?
• Types of Stages
o Table Stages
o User Stages Internal
o Named Stages External
o Stages
• Creating Stages
• Data Loading/Unloading from Stages
• Querying Data in Staged Files
8. Snowpipe (Continuous Data Ingestion)
• Introduction to Snowpipe
• Load CSV, JSON, Parquet from S3 using Snowpipe
9. Sharing Data in Snowflake
• Introduction to Data Sharing
• Data Providers & Consumers
www.survitechnologies.com 90000 12244
• Creating Shares
• Adding/Removing
• Consumer Accounts Reader Account
Setup & Management
10. Tasks in Snowflake – Scheduling Service
• Introduction to Tasks
• Task Tree Implement
• Standalone Task Check Task
• History
11. Streams – Change Data Capture (CDC)
• Introduction to Streams
• Insert/Delete/Update Operations
12. Time Travel
• Configure Retention Time
• Query Historical Results
• Clone & Restore Objects
13. Fail Safe
• Introduction
• Check Storage Consumption
• Storage Charges
14. Zero Copy Cloning
• Clone Database, Schema, Tables, Pipes, Streams, Tasks
•
DML on Cloned Tables
• Time Travel Cloning
• Swap Tables
15. SnowSQL
• Download & Installation
• Create Database/Tables
•
Data Load & Unload
16. Managing Your Snowflake Account
• System Usage & Billing Understanding Snowflake
• Credit & Storage Usage
www.survitechnologies.com 90000 12244
• Monitoring Usage Resource
• Monitors Parameter & User
• Management
17. Snowflake Data Transfer Billing
18. Types of Tables
•
Permanent, Transient, Temporary Tables & Databases
19. Micro-Partitioning
• Traditional vs Snowflake Partitioning
• Micro-Partition Structure & Advantages
• Query Processing
20. Managing Security
• System Defined & Custom Roles User
• Creation & Role Grants
• MFA
• Access Control: DAC & RBAC Data
• Encryption (including Customer-Side)
21. Snowflake Pricing
• What are Snowflake Credits?
• Serverless Features Cost
• Storage, Compute, Cloud Services,
• Data Transfer Costs
Credit Usage Tracking
22. Performance Tuning
• Dedicated Virtual Warehouses
•
Scaling Up/Down
• Caching & Clustering
23. Caching in Snowflake
• Cache Introduction
• Types of Cache
24. Views and Materialized Views
• Standard vs Secure Views
• Materialized Views & Refresh Logic
www.survitechnologies.com 90000 12244
25. Dyn amic Data Masking
Create, Apply, Alter Masking Policies
Row-Level Security Setup (Mini Project)
26. Resource Monitors
Introduction
Properties & Triggers
Creating via UI & SQL
27. Data Sampling
Why & How
Hands-On Sampling
28. Partner Connect
Available Tools
Matillion ETL Trial
29. Visualization
Power BI & Tableau Integration
Installation & Working with Data
Projects
Mini Project: Setup Row-Level Security
Major Project: End-to-End Data Pipeline (AWS to Snowflake)
www.survitechnologies.com 90000 12244
