Snowflake Snowpark Application Developer Training

Price
$1,000.00 USD

Duration
1 Day

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

This one-day course covers key Snowpark features for developing applications in Snowflake and is intended for practitioners who will be building Snowpark application solutions in Snowflake. The emphasis of this course is on a variety of application developer capabilities rather than core programming skills. The course consists of lectures, demos, labs, and discussions.

Course Objectives

  • Describe Snowflake’s notebook capabilities.
  • Create and work with Snowflake Notebooks.
  • Create reusable code as User-defined Table Functions (UDTFs).
  • Use DML to create and manage tables.
  • Solve problems with Snowsight Python Worksheets.
  • Record the activity of your Snowflake programs with logging.
  • Develop competency in using pandas on Snowflake.
  • Process unstructured data using Snowflake User-defined Functions (UDFs) and stored procedures

Who Should Attend?

  • Data Engineers
  • Data Scientists
  • Data Application Developers
  • Database Architects
  • Database Administrators
  • Data Analysts with programming experience
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

  • Completion of “Snowpark DataFrame Programming” or prior knowledge and experience with DataFrame programming: Creation, Transformation, Actions, PySpark, UDFs, and Stored Procedures.
  • Prior knowledge and experience with Snowflake accounts, roles, virtual warehouses, databases, tables, and views.
  • Previous data warehouse knowledge and experience.
  • Proficiency in writing code in Python.
  • Familiarity with Snowflake objects and basic SQL.

Agenda

1 - Snowpark Review

  • What is Snowpark?
  • Snowpark Uses
  • Snowpark Architecture
  • Snowpark Setup

2 - DML Using Table DataFrames

  • DataFrames are Immutable
  • A Table is a Mutable DataFrame
  • Creating a Table
  • Deleting Rows From a Table
  • Updating Rows in a Table
  • Merging Rows in a Table
  • Understanding Views

3 - User-defined Functions (UDFs) Recap and Developing User-defined Table Functions (UDTFs)

  • Creating and Registering UDFs
  • Creating and Using Python User-defined Table Functions (UDTFs)

4 - Developing Stored Procedures

  • Lambda Example
  • Anonymous Python Stored Procedures: Really?
  • CALL (with Anonymous Procedure)
  • Using sproc(... ) as a Decorator
  • Authoring a Stored Procedure Using DDL

5 - Working with Snowsight Python Worksheets

  • Additional Overhead and Costs
  • Steps to using Snowsight Python Worksheets
  • Test Handler

6 - Python Vectorized UDFs

  • Proper Testing
  • Create a Non-Vectorized UDF and Use it in a Transformation
  • Test a Non-Vectorized UDF and Measure Performance
  • Create a Vectorized UDF and Use it in a Transformation
  • Test Handler

7 - Processing Unstructured Data with Snowpark

  • Steps in Processing Unstructured Data
  • Stages
  • Directory Tables
  • Access URLs
  • Encryption for Internal Stages
  • Processing Unstructured Data in UDFs
  • Registering the UDF
  • Invoking the UDF
  • Unstructured Data Best Practices

8 - Logging Messages With Snowpark

  • Logging Introduction
  • Log Entries vs Trace Events
  • Event Tables
  • Setting Log Levels
  • Logging From Objects
  • Emitting Trace Events
  • Querying Over Log Messages

9 - Introduction to Snowflake Notebooks

  • Creating a Notebook
  • Notebook Cell Basics
  • Running Notebook Cells
  • Editing Cells
  • Import Python Packages
  • Running SQL and Python Cells

10 - Using Pandas with Snowflake Notebooks

  • Snowflake Notebooks
  • Introduction to Pandas on Snowflake
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3606107E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons