• 30 N Gould St Ste R Sheridan, WY 82801, USA
Join us for a FREE hands-on Meetup webinar on Deep Dive into Autoscaling in Apache Flink | Friday, March 28th, 2025 · 5:00 PM IST/ 07:30 AM EDT Join us for a FREE hands-on Meetup webinar on Deep Dive into Autoscaling in Apache Flink | Friday, March 28th, 2025 · 5:00 PM IST/ 07:30 AM EDT
Search
Close this search box.
Search
Close this search box.
Contact Us

Snowflake Snowpark DataFrame Programming

Efficient Data Processing and Machine Learning in Snowflake Using Snowpark
Enroll Now

Duration

1 Day

Level

Fundamentals Level Level

Design and Tailor this course

Official Course

Edit Content

This one-day course covers key Snowpark concepts, features, and programming constructs intended for practi-tioners who will be building DataFrame data solutions in Snowflake. This course consists of lectures, demos, labs, and discussions.

ACQUIRED SKILLS

  • 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.
  • Action DataFrame objects to process results client-side or persist results in Snowflake.
  • Create shareable and reusable code as User-Defined Functions (UDFs).
  • Encapsulate a sequence of operations or conditional logic into a single, reusable object with Stored Procedures.
Edit Content
  • Data Engineers
  • Data Scientists
  • Data Application Developers
  • Database Architects
  • Database Administrators
  • Data Analysts with programming experience
Edit Content
  • Snowpark Technical Overview
  • Getting Started with the Snowpark API
  • Setting Up Snowflake Connections and Exploring Multiple Authentication Methods
  • Discovering What DataFrames are in Snowpark and How They Run on Snowflake’s Elastic Compute Engine
  • Exploring Multiple Methods to Create a DataFrame Object
  • Key Concepts of Programming in Snowpark DataFrames Including Schemas, Data Types, and Lazy Evalua-tion
  • 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
  • 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
  • Writing a Basic UDF in Snowpark
  • Registering and Granting Access to UDFs to Share Code with Others
  • Making Dependencies Available to Your Code
  • Using a Python Worksheet to Create and Deploy a Stored Procedure
Edit Content
  • Snowflake Hands-on Essentials: “Data Warehousing Workshop” or equivalent knowledge required.
  • Previous data warehouse knowledge is assumed.
  • Basic proficiency writing code in one of the following languages: Java, Scala, or Python.
  • Familiarity with Snowflake objects and basic SQL.
Download PDF

Stay ahead with DataCouch! Your partner in mastering the latest advancements in AI, Data Science, DevOps, and more.

Quick Links

our Offerings

Get in touch

Instagram Facebook X-twitter Linkedin Youtube Meetup Medium

Sign up for DataCouch Communications

Copyright 2025 © DataCouch

Connect

we'd love to have your feedback on your experience so far