TRAINING

Enroll Now

Snowflake

Introduction to Snowflake

• ETL, DWH, BI
• Introduction to Snowflake ‘Creating Snowflake Account
• Create DWH, DB, Schema and Tables
• Roles in Snowflake
• Testing Snowflake

Architecture

• Columnar & Micro-partition storage
• Shared Disk and Shared-Nothing Architectures
• Multi-cluster, Shared Data Architecture
• Cloud Service Layer
• Storage Layer
• Compute Layer

Data Marketplace

• What is Snowflake Data Marketplace?
• Types of Data Listing,
• An Overview of Data Exchange

Account Information

• Supported Cloud Partners
• Snowflake Editions
• Geographical Locations

Connecting to SnowflakeInstalling

• SnowSql - Configuring the SnowSQL, SnowSQL Exlamatory Commands, PUT and GET commands, VALIDATE - table function
• Web User Interface Understanding Sessions
• Command Line Interface
• Third party Applications
• Snowflake Pricing
• Resource Monitors

Micro-Partitioning

• Traditional Partitioning v/s Snowflake Partitioning
• Advantages
• Structure
• Query processing
• Micro-Partitioning and Clustering
• Creating Cluster Tables
• Cluster Tables with expressions
• Order By Clause
• Manual re-clustering
• Best practices in Micro-Partitioning and Clustering

Data loading and unloading

• Load Data from AWS
• Load Data from Azure
• Load Data from GCP

Bulk Loading DATA / Big Data

• Preparing Data for loading
• Syntax of COPY command
• Putting data into stages from local systems
• Load data from stages
• Managing regular data load

Connecting to SnowflakeInstalling

• SnowSql - Configuring the SnowSQL, SnowSQL Exlamatory Commands, PUT and GET commands, VALIDATE - table function
• Web User Interface Understanding Sessions
• Command Line Interface
• Third party Applications
• Snowflake Pricing
• Resource Monitors