Overview
This one‐day course covers key Snowpark concepts, features, and programming constructs. It is intended for practitioners who will be building DataFrame data solutions in Snowflake. The course consists of lectures, demos, labs, and discussions.
Skills Covered
- Describe Snowpark’s client-side and server-side capabilities.
- Connect to Snowflake using a Snowpark Session object.
- Query data sources as Snowpark DataFrame objects.
- Perform basic and advanced data transformations using a library of DataFrame functions.
- Process DataFrame objects to return results client-side or persist results in Snowflake.
- Create shareable and reusable code as User-Defined Functions (UDFs).
- Encapsulate sequences of operations or conditional logic into reusable Stored Procedures.
Prerequisites
- Recommended completion of the “Snowflake Multi-Factor Authentication (MFA) Essentials” free on-demand course.
- Completion of Snowflake Hands-on Essentials: “Data Warehousing Workshop” or equivalent knowledge.
- Previous data warehouse knowledge is assumed.
- Basic proficiency writing code in Java, Scala, or Python.
- Familiarity with Snowflake objects and basic SQL.
Target Audience
- Data Engineers
- Data Scientists
- Data Application Developers
- Database Architects
- Database Administrators
- Data Analysts with programming experience.
Snowpark Overview
- Snowpark Technical Overview
- Getting Started with the Snowpark API
- Discovering what DataFrames are in Snowpark and how they run on Snowflake’s elastic compute engine
Creating Snowpark DataFrames
- Exploring multiple methods to create a DataFrame object
- Key concepts of programming in Snowpark DataFrames including schemas, data types, and lazy evaluation
- Constructing basic create statements
Transforming DataFrames: Basic and Advanced Operations
- Applying column operations for filtering and transforming data
- Using scalar functions and operators
- Sorting and limiting results
- Performing aggregate and set-based operations on DataFrames
- Transforming semi-structured data in DataFrames
Actions on DataFrames: Evaluating and Persisting
- Identifying the differences between and how to use DataFrame actions and transformations
- Evaluating DataFrame transformations with actions that return data to the client-side
- Publishing logical DataFrame operations as views
- Creating and appending Snowflake tables with DataFrame results
Creating and Registering User-Defined Functions (UDFs)
- Writing a basic UDF in Snowpark
- Registering UDFs
Authoring a Stored Procedure
- Making dependencies available to your code
- Using a Python Worksheet to create and deploy a Stored Procedure.
Exam & Certification
SnowPro® Specialty: Snowpark
The SnowPro® Specialty: Snowpark Certification Exam will validate specialized knowledge, skills, and best practices used to build Snowpark DataFrame data solutions in Snowflake including key concepts, features, and programming constructs.
This certification will test the ability to:
- Perform data transformations using Snowpark DataFrame functions
- Query data sources as Snowpark DataFrame objects
- Connect to Snowflake using a Snowpark session object
- Process results client-side or persist results in Snowflake through Snowpark DataFrame actions
- Design a sequence of operations or conditional logic with Snowpark stored procedures
Training & Certification Guide
Why train with Trainocate
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
