Getting Started with Snowflake | Datawarehouse in the Cloud

Explore Snowflake Essentials, Building a Virtual / Cloud Based Warehouse, Work with SnowSQL, SnowPipe and More

TTSNWF100

Intermediate

3 Days

Course Overview

Snowflake is the leading solution for warehousing in the cloud. It is built for the cloud. Snowflake delivers the performance, concurrency and simplicity needed to store and analyze an organization’s data in one complete solution. Snowflake’s technology combines the power of data warehousing, the flexibility of big data platforms and the elasticity of the cloud at a fraction of the cost of traditional solutions.

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. 

 

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Fresh Spring Savings!
Buy One Get One Free!

Enroll by May 31 in any TWO public classes in 2022 for the price of ONE! 

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More