Getting Started with Snowflake | Datawarehouse in the Cloud (Vendor Independent Training)

Course Objectives

Working within an engaging, hands-on learning environment led by our expert practitioner, attendees will explore:

• Getting Started with Snowflake
• Building a Virtual Warehouse
• Getting Started with SnowSQL
• Continuous Data Loading with SnowPipe
• Snowflake Security Overview

Optional Additional Topics can include:

• Snowflake objects
• Caching in Snowflake and How different caching types works
• Reading a Query Profile & How it helps
• Data Loading
• Roles and Inheritance
• Semi-Structured Data
• Building Semi-structured from Relational (using object_construct function)
• External Stage Vs. External Tables Vs. External Tables +
• Materialized Views
• Snowflake - Python Connector, Spark Connector

Need different skills or topics?  If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate.  We offer additional Snowflake, data analytics, data warehousing, scripting, cloud, visualization and other related topics that may be blended with this course for a track that best suits your needs.  We will collaborate with you to design a targeted skills-focused agenda that meets your unique needs and goals.

Course Prerequisites

This is an Intermediate level course designed for DevOps team members, Developers, and Managers who possess a strong IT background and basic SQL skills.

Next Steps / Follow-On Training: We offer a wide array of Analytics, DevOps, Programming, Cloud or other related hands-on, skills-focused courses. Please contact us for recommendations for next steps in your learning journey based on your unique needs and goals.

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We will work with you to tune this course and level of coverage to target the skills you need most.

Getting Started with Snowflake

• Planning
• Deciding on a Snowflake Edition
• Choosing a Cloud Provider and Region

Building a Virtual Warehouse

• Overview of Snowflake Virtual Warehouses
• Warehouse Sizes and Features
• Multicluster Virtual Warehouses
• Virtual Warehouse Considerations
• Query Design
• Caching Impacts
• Scaling
• Building a Snowflake Virtual Warehouse
• Creating a Virtual Warehouse
• Starting, Resuming, Suspending, and Resizing
• Using a Warehouse
• Setting Up Load Monitoring

Getting Started with SnowSQL

• Installing SnowSQL
• Configuring SnowSQL
• Connection Settings
• Configuration Variables
• SnowSQL Commands
• Multiple Connection Names
• Data Loading with SnowSQL

Continuous Data Loading with SnowPipe

• Loading Data Continuously
• SnowPipe Auto-Ingest
• SnowPipe REST API Using AWS Lambda

Snowflake Security Overview

• Snowflake Security Reference Architecture
• Virtual Private Cloud
• Physical Security
• Network and Site Access
• Account and User Authentication
• Object Security
• Data Security
• Security Validation
• Snowflake Audit and Logging
• Penetration Testing

Optional Additional Topics

Snowflake objects

• Table, View, Stored Procedure, UDF, Stage, File Format, Pipe, Sequence

Caching in Snowflake and How different caching types works

• Metadata Cache
• Query Result Cache
• Warehouse Data Cache

Reading a Query Profile & How it helps

Data Loading

• Related to File format, Stage, DB/Schema/Table, Pipe
• Bulk Loading (using COPY command)
• Data Loading Transformations and Validations
• Data Unloading
• Continuous Loading (using SnowPipe)

Roles and Inheritance

Semi-Structured Data

• JSON, CSV, XML samples
• View, Query, and Flatten Data
• Loading & Unloading
• Time Travel
• Clustering

Building Semi-structured from Relational (using object_construct function)

External Stage Vs. External Tables Vs. External Tables +

Materialized Views

Snowflake - Python Connector, Spark Connector

Course Materials

Each student will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and links (as applicable). Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Lab Setup Made Simple.   All course labs and solutions, data sets, Tableau course software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.