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