Snowflake Snowpark DataFrame Programming Training Logo

Snowflake Snowpark DataFrame Programming Training

Live Online & Classroom Enterprise Training

Snowflake Snowpark DataFrame Programming focuses on transforming and processing data using Snowpark DataFrame APIs within Snowflake. It equips learners to build efficient, scalable data transformations using Python-based DataFrame operations executed natively in the Snowflake Data Cloud.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Snowflake Snowpark DataFrame Programming Training about?

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.

What are the objectives of Snowflake Snowpark DataFrame Programming Training ?

  • 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 built-in DataFrame functions.
  • Execute DataFrame actions to process results client-side or persist results in Snowflake.
  • Create shareable and reusable code using User-Defined Functions (UDFs).
  • Encapsulate sequences of operations or conditional logic into reusable objects using stored procedures.

Who is Snowflake Snowpark DataFrame Programming Training for?

  • Data Engineers
  • Data Scientists
  • Data Application Developers
  • Database Architects
  • Database Administrators
  • Data Analysts with programming experience

What are the prerequisites for Snowflake Snowpark DataFrame Programming Training?

  • 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.
  • Prior knowledge of data warehouse concepts.
  • Basic proficiency in writing code in one of the following languages: Java, Scala, or Python.
  • Familiarity with Snowflake objects and basic SQL.

Available Training Modes

Live Online Training

1 Days

Classroom Training

1 Days

Course Outline Expand All

Expand All

  • Snowpark technical overview
  • Getting started with the Snowpark API
  • Understanding Snowpark DataFrames and how they run on Snowflake’s elastic compute engine
  • Exploring multiple methods to create a DataFrame object
  • Key programming concepts in Snowpark DataFrames, including schemas, data types, and lazy evaluation
  • Constructing basic CREATE statements
  • 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
  • Understanding the difference between DataFrame actions and transformations
  • Evaluating DataFrame transformations using actions that return results to the client side
  • Publishing logical DataFrame operations as views
  • Creating and appending Snowflake tables from DataFrame results
  • Writing a basic UDF using Snowpark
  • Registering UDFs in Snowflake
  • Making dependencies available to your code
  • Using a Python Worksheet to create and deploy a stored procedure

Who is the instructor for this training?

The trainer for this Snowflake Snowpark DataFrame Programming Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews