SNOWFLAKE ASCENT: FOUNDATIONS

WHAT TO EXPECT

Ascent: Foundations is a complimentary, 1-day hands-on workshop, designed for new Snowflake users.  It’s your chance to expand your working knowledge of the platform by immersing yourself in the Snowflake Data Cloud for a full day.

WHO SHOULD ATTEND

Snowflake Ascent: Foundations has been designed for Data Engineers, Data Scientists, Database Administrators and Data Architects who are new to Snowflake.

It’s not for those who have already undertaken Snowflake Fundamentals, or have a SnowPro Core Certification.

COURSE PREREQUISITES 

• Bring your own laptop and charger
• Previous Data Warehouse knowledge is assumed

Cost to Attend: Free
GOVERNMENT EMPLOYEES: Please be advised that Snowflake will be providing food and beverage with an approximate market value of $70 NZD and a gift valued at $21 NZD at this event. By accepting the food and beverage and/or gift, you are confirming that you are not prohibited or otherwise restricted from doing so by virtue of your government employment. If you are unable to accept the food/beverage gratuitously, please contact [email protected]

TOPICS COVERED

Overview and Architecture

• Overview
• Snowflake Structure
• Using Snowsight
• Storage Layer
• Compute Layer
• Cloud Services Layer and Snowgrid

Data Protection Features

• Cloning
• Time Travel
• Introduction to Replication

Metadata and Caching in Snowflake

• Metadata
• Query Result Cache
• Data Cache

Query Performance

• Using Explain
• Query Profile

Data Loading

• Data Loading Objects
• Data Loading Process
• Transformation and Copy Options