Snowflake
Overview
This training program on Snowflake is a 2-day course which covers how to explore, load, visualize and also extract insights from the Snowflake Platform.Topics Covered are:
-
- Participants will understand the overview of Snowflake’s key features & its architecture
- Participants will Load and work with new datasets
- Participants will Review key SQL extensibility features
- Participants will Query and inspect the data using SQL core constructs
- Participants will Employ best practices for working with semi-structured data
- Participants will Discuss query caching performance capabilities
- Participants will Visualizing data outside of Snowflake
2 Days
Pre-Requisites
Participants must have basic knowledge of SQL
Course Outline
- Snowflake Overview
- Architecture 101
- How to use the Snowflake UI & ecosystem
- Ingesting new data into Snowflake Tables
- Working with various SQL Data Types
- Discussing streaming data
- Ingestion best practices & anti-patterns
- View the Schema
- Filtering data examples & best practices
- Sorting data & performance considerations
- Commonly used functions
- Save & export data output
- Time Travel queries
- Result set cache
- Metadata cache
- Query data cache
- Best practices of using caching for performance and cost optimization
- Using Snowflakes high-performing guesstimate and the estimation features
- Join and Union queries & tuning technique
- Perform advanced analytic tasks using additional SQL querying capabilities which also includes the subqueries, the common table expressions, and the analytic functions
- User-defined functions
- Stored Procedures
- Regular Views & Secured Views
- Data source formats
- Support of native data types
- SQL Operations (Grouping, Sorting & more)
- Built-in functions for
- Traversing
- flattening,
- nesting of semi-structured data
- Connecting a BI Tool to Snowflake
- Exploring & Visualizing data outside of Snowflake