Snowflake Training Overview
This Introduction to the Snowflake Cloud Data Platform training course walks attendees through Snowflake's Web UI, teaches them how to design Data Warehouses in Snowflake, query a Snowflake database, and more.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Explore the Snowflake Web UI
- Create and work with databases in Snowflake
- Query data in Snowflake
- Work with Common Table Expressions (CTEs)
- Create window functions in Snowflake;
- Understand stored procedures and (User-Defined Functions) UDFs in Snowflake
- Work with the SnowSQL Command-Line Interface (CLI)
- Understand Snowflake's users and roles
Prerequisites
Attendees must have basic knowledge of programming and SQL.
Outline
Expand All | Collapse All
Introduction to the Snowflake Cloud Data Platform
- What is Snowflake?
- Certifications
- Snowflake Conceptual Architecture
- Core Underlying Design Considerations
- Core Services and Tools
- Snowflake Editions
- The Standard Edition
- The Enterprise Edition
- The Business Critical Edition
- Virtual Private Snowflake
- Billing: The Cost Components
- Data Storage Segments
- Parts of Snowflake that Incur Compute-related Costs
Snowflake's Web UI
- Web UI (Web Portal)
- The Landing Page
- Snowflake Roles
- The Roles UI
- Databases
- Shares
- Data Marketplace
- The Warehouses UI
- Worksheets
- History
- A History Sample
- Account
- Operational Transparency: Controlling the Usage of Your Account
- Create Network Policy Dialog (under Account > Policies)
- Preview App
Designing Data Warehouses in Snowflake
- What is a Virtual Data Warehouse?
- The Warehouse-Database Relationship
- Matching Your Needs
- The Auto Suspend/Resume Features
- Multi-cluster Data Warehouses
- The Concept of the Snowflake Compute Credit
- Compute Sizing
- Example of Calculating Monthly Compute Charges (Credits)
- Operations
- Creating a New Warehouse
- Database Objects
- Tables
- Table Storage Types
- Table Constraints
- Search Optimization Service
- Table Data Types
- Data Loading
- Views
- Zero-Copy Cloning Feature
- The Programming Capability
- Continuous Data Protection Lifecycle
Querying for Insights in Snowflake
- Supported SQL Standards
- Ways to Query Data in Snowflake
- Snowsight Experience
- The TOP/LIMIT Syntax
- Comments
- Pagination
- Support for Window Functions
- CTEs (Common Table Expressions)
- Approximation Functions
Designing Data Warehouses in Snowflake
- The Programming Capability
- Returning a Value
- User-defined Functions (UDFs)
- UDF-Related DDL Commands
- The CREATE FUNCTION DDL
- A UDF Example
- Stored Procedures
- DDL Commands Related to Stored Procedures
- JavaScript-based Stored Procedure
- A Stored Procedure Example
- Accessing the Return Value of Stored Procedures
- External Functions
Data Import and Export in Snowflake
- Bringing Data Into Snowflake: the Import Tools
- Data Stages
- Import Process using a Stage
- Example of Using the Put Command
- Example of Using the Copy Into Command for Data Import
- Snowpipe
- Using Snowpipe
- Taking Data out of Snowflake: the Export Tools
- The Export Process
- Data Export Example
Conclusion
Training Materials
All Snowflake training students receive comprehensive courseware.
Software Requirements
All attendees will need access to a Snowflake SQL environment with Accelebrate’s sample data loaded.
