Snowflake Training

About the course

Harnessing the power of the cloud, Snowflake has unique capabilities in the form of unlimited and instant scalability, making it perhaps the ultimate data warehouse solution. Cloud elasticity is very much at the heart of Snowflake – making its unique architecture and value proposition difficult to compete with in the market.

KEY FEATURES

Curriculum

From an end user perspective, Snowflake is incredibly appealing. Building data warehouses and petabyte data scaled solutions without having to worry about on-prem compute and storage issues means your focus remains solely on the data itself and even more importantly, the analytics you derive from

Course Contents:
o Advantages of Cloud data warehousing.
o Describe about various popular cloud data warehouses
o Redshift (AWS)
o Snowflake
o Azure synapse (Microsoft)
Snowflake General
Introduction
o Pricing
o Snowflake Editions
o Standard Edition
o Enterprise Edition
o Business Critical Edition
o Virtual Private Snowflake (VPS)
o Supported Cloud Platforms
o Amazon Web Services (AWS)
o Google Cloud Platform (GCP)
o Microsoft Azure (Azure)
Connected to Snowflake
o How to create snowflake account
o Different features in Snowflake.
o Web interface overview and how to use
o SnowSql tool introduction and Usage.
Snowflake Architecture
o Overview
o Architecture layers – Storage, Query Processing and Cloud Services
Loading / Unloading Data Into/From Snowflake
o Overview of Data Loading
o Summary of Data Loading Features
o Data Loading Considerations
o Preparing to Load Data
o Bulk Loading Using COPY
o Loading Continuously Using Snowpipe
o Loading Using the Web Interface (Limited)
o Querying Data in Staged Files
o Querying Metadata for Staged Files
o Transforming Data During a Load
Semi-structured Data — Key concepts and tasks for working with JSON and other types
o Introduction to Semi-structured Data
o Semi-structured Data Considerations
o Tutorial: JSON Basics
Virtual warehouses
o Overview of Warehouses
o Multi-cluster Warehouses
o Warehouse Considerations
o Working with Warehouses
o Monitoring Warehouse Load
Databases, Tables & Views
o Understanding Snowflake Table Structures
o Working with Temporary and Transient Tables
o Working with External Tables
o Overview of Views
o Working with Secure Views
o Working with Materialized Views
o Table Design Considerations
o Cloning Considerations
o Data Storage Considerations
Timetravel and Fail Safe
o Understanding & Using Time Travel
o Understanding & Viewing Fail-safe
o Storage Costs for Time Travel and Fail-safe
Sharing Data In Snowflake
o Introduction to Secure Data Sharing
o Overview of the Product Offerings for Secure Data Sharing
o Granting Data Exchange Administrator Privileges to Other Roles
o Secure Direct Data Share
o Data Providers
o Working with Shares
o Sharing Data from Multiple Databases
o Sharing Data Securely Across Regions and Cloud Platforms
o Using Secure Objects to Control Data Access
o Managing Reader Accounts
o Configuring a Reader Account
o Enabling Sharing from a Business-Critical Account to a non-Business Critical
Account
Managing Your Snowflake Account
o System Defined roles
 ACCONTADMIN
 SECURITYADMIN
 SYSADMIN
 PUBLIC
o Custom Roles
Working with Streams and Tasks
o Introduction to Streams & Types
o Live example demonstration
o Introduction to tasks
o Scheduling Streams through Tasks