SNOWFLAKE ASCENT

Essential hands-on training to begin your data journey.

Virtual Event

31 January

8:45 AM AEDT/10:45 AM NZDT

January 31

Due to overwhelming demand, this event has reached capacity and registrations are now closed. To continue your journey with Snowflake, we invite you to participate in Snowflake Discover, February 10-13. Find out more details here.

WHAT TO EXPECT

Snowflake Ascent is a step-by-step live and free, AI Data Cloud training conference delivered by Snowflake’s technical instructors. Our instructors will outline the AI Data Cloud architecture including data warehousing, data lakes, data engineering, data science, data applications and data sharing. The instructor-led hand-on labs will show you how to set-up your instance and accelerate your ability to unify, integrate, and share previously siloed data with virtually unlimited scale and concurrency. You will be able to follow the training with your free-trial account and have your questions answered.

WHO SHOULD ATTEND

Snowflake Ascent has been designed for individuals with limited experience using Snowflake looking to get-started and accelerate their knowledge with the AI Data Cloud – including IT managers, Data Architects, Engineers, Scientists, Administrators and Developers.

YOU WILL LEARN HOW TO

Set-up and Navigate the Snowflake User Interface
Create Database and Compute Resources
Create Stages and Roles
Load and Share Data Securely
Manage Performance

COURSE PREREQUISITES

Follow the steps to enrol for the “Snowflake Ascent Workshop”
A Snowflake Community account (sign up here)
A Snowflake free-trial account (sign up here)
Students are requested to create an Enterprise Edition trial account on AWS – Region = Canada (Central)

AGENDA – AEDT | NZDT – Time Friendly

START TIME SESSION DETAILS

8:45 AM – 9:15 AM AEDT

Welcome & Course Set-Up (optional)

9:15 AM – 9:45 AM AEDT

Introduction to Snowflake

This section will outline the Snowflake platform, starting with What is the AI Data Cloud, an end to end on the architecture including core workloads – data warehousing, data lakes, data engineering, data science, data applications and data sharing. You will learn how to set-up a trial account, how to navigate between the classic UI and the new Snowsight UI, and what is an Account URL.

9:45 AM – 10:05 AM AEDT

Module 1: Identity and Access with Snowflake

This section will outline the basic predefined roles in Snowflake, you will learn about roles and how they relate to both database and warehouse visibility.

10:05 AM – 10:25 AM AEDT

Module 2: Data Containers

In this section, you will learn about creating databases, dropping and creating schemas, how to create a worksheet and run code as well as how to use the SHOW commands.

10:25 AM – 10:45 AM AEDT

Break

10:45 AM – 11:05 AM AEDT

Module 3: Tables, Data Types and Loading Data

In this section, you will learn about tables and data types, and how to create tables using SQL including how to insert data into a new table.

11:05 AM – 11:25 AM AEDT

Module 4: Worksheets and Warehouses

In this section, you will learn what worksheets and warehouses are and how you can use them to write and execute queries.

11:25 AM – 11:45 AM AEDT

Module 5: File Formats and the Load Wizard

In this section, you will learn how to prepare data for loading, how to massage it prior to load and how to set up file formats, how to load tables using the Load Wizard and then view the newly inserted data.

11:45 AM – 12:15 PM AEDT

Module 6: Staging Data

In this section, you will learn what a Snowflake stage object is and how it is used in the data loading process. You will also learn how to use the LIST command to discover the contents of a stage and how to use the COPY INTO statement to load data into a table from a stage.

12:15 PM – 12:45 PM AEDT

Break

12:45 PM – 1:05 PM AEDT

Module 7: Data Storage Structures

In this section, you will learn how to model data effectively in Snowflake so you can create and populate data storage structures that will give you the answers you need.

1:05 PM – 1:25 PM AEDT

Module 8: Intro to Semi-Structured Data

In this section, you will learn the basics of how Snowflake natively supports the storage and querying of semi-structured data.

1:25 PM – 1:45 PM AEDT

Module 9: Nested Semi-Structured Data

In this section, you will load and query nested semi-structured data.

1:45 PM – 2:05 PM AEDT

Journey to Snowflake Certification

This section will bring all of the module components together and outline your path Snowflake Certification.

2:05 PM – 4:00 PM AEDT

Modules Conclusion and Extended Q&A

Technical Instructors

Ravi Gurbaxani

Manager, Delivery
Snowflake

Ravi Gurbaxani

Manager, Delivery
Snowflake