Snowflake
A Snowflake course typically refers to training programs or educational resources focused on teaching how to use and manage Snowflake, a cloud-based data warehousing platform. Snowflake is known for its ability to handle large-scale data storage, processing, and analytics with high efficiency and scalability.
Snowflake has been widely adopted across various industries due to its robust data warehousing capabilities
INTRODUCTION
- Introduction to Snowflake
- Create a Free Snowflake Account
- CORE CONCEPTS
- Explore - Databases, Schemas and Tables
- Snowflake Architecture
- Virtual Warehouses (Compute Engine) – Intro
- Different Roles in Snowflake
SNOWFLAKE PRICING
- Snowflake Pricing - Overview
- What are Snowflake Credits
- Snowflake Editions
- Storage Cost
RESOURCE MONITORING
- Resource Monitors - Introduction
- Properties of Resource Monitor
- Suspension or Resumption
- Detailed Example - How Resource Monitors Work
- Create a Resource Monitor using WebUI
MICRO PARTITIONING
- Partitioning in Traditional Data Warehouses
- Partitioning in Snowflake - Micro Partitioning
- Advantages of Micro-Partitioning
- Structure of Micro-Partition
- Query Processing in Snowflake
CLUSTERING IN SF
- Clustering Introduction
- Clustering Keys
- Clustering Metadata
- Clustering Depth
- Automatic Re-clustering
- Query History
QUERY HISTORY & CACHING
- Detailed Lab - Query History
- SQL Queries to fetch Query History
- Caching in Snowflake
- Caching - Detailed using Examples
CODING PART
- Worksheets - Databases, Schemas, Tables, etc.
- Setting up Context/Parameters for worksheet
- Run the first SQL statement
- More about Worksheet's Results section
LOAD DATA FROM AWS
- What is AWS s3 and how to create buckets under it
- What is IAM (Identity & Access Management)
- Create an IAM Group
- Create IAM User
- Create AWS IAM Role
- Upload data to AWS s3 using the web console
- Loading Data - Create Table Schema, Integration object
- Loading CSV Data to Snowflake using COPY command
- Load Complete CSV data from S3
SNOWPIPE- CONTINUE DATA INGESTION PROCESS
- Introduction to Snowpipe
- Load CSV Data from s3 using Snowpipe
- DIFFERENT TABLES
Different Types of Tables
- Create Permanent & Transient Database
- Create Permanent & Transient Schema
- Create Permanent & Transient Schema
- Create Temporary, Permanent & Transient Table
- Convert the Table to a Different type
TIME TRAVEL WORKS WITH THE HISTORY OF OBJECTS
- What is Time Travel - Detailed
- Set & Alter Retention Time Property
- Query Historical Results
- Clone Historical Objects
- Restore the Dropped Objects [IMP]
FAIL SAFE
- What is Failsafe - Detailed Overview
- Check Failsafe Storage Consumption
TASKS – SCHEDULING SERVICE
- Introduction to Tasks
- What is a Tree of Tasks
- How to implement a Standalone Task
- Check Tasks History
STREAMS – CDC (CHANGE DATA CAPTURE)
- Introduction to Streams
- How Streams work under the hood
- Capture & Process INSERT Operations
- Capture & Process UPDATE Operations
- Capture & Process DELETE Operations
- How streams work within a Transaction
ZERO-COPY CLONING
- What is Zero-Copy Cloning
- Clone Database, Pipes, Streams, Tasks & Stages
- Clone Schema & Tables
SECURE DATA SHARING
- Data Sharing - Definition
- Provider and Consumer Accounts
- Allowed list of objects to Share
- How Data Sharing Works on Snowflake
- Data Sharing - Architecture
MATERIALIZED VIEWS
- Materialized Views - Introduction
- Materialized Views - When to create
- Materialized Views - Advantages
- Materialized Views - Limitations
SECURE VIEWS
- Secure Views - Introduction
- Secure Views - Hands On
MINI PROJECT
- Understand the Requirements
- Set up Users and Custom Roles
- Grant Privileges to custom Roles
SECURITY- DYNAMIC DATA MASKING COLUMN LEVEL
- Data Masking - Introduction
- Data Masking - Detailed overview
- Data Masking - Hands-on
PARTNER CONNECT
- Introduction to Partner Connect
- Know about available Tools
- SnowSQL (CLI Client) - Installation, Configuring and Usage