Snowflake Snowpark Application Developer Training

Live Online & Classroom Enterprise Training

Snowflake Snowpark Application Developer focuses on building scalable data applications using Snowpark APIs within the Snowflake Data Cloud. It equips developers to create, deploy, and optimize data-driven applications using Python and Snowflake-native development frameworks.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Snowflake Snowpark Application Developer Training about?

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.

What are the objectives of Snowflake Snowpark Application Developer Training ?

Describe Snowflake’s notebook capabilities.
Create and work with Snowflake Notebooks.
Create reusable code using User-Defined Table Functions (UDTFs).
Use DML to create and manage tables.
Solve problems using Snowsight Python Worksheets.
Record and track Snowflake program activity using logging.
Develop proficiency in using pandas on Snowflake.
Process unstructured data using Snowflake User-Defined Functions (UDFs) and stored procedures.

Who is Snowflake Snowpark Application Developer 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 Application Developer Training?

Recommended completion of the Snowflake Multi-Factor Authentication (MFA) Essentials free, on-demand course.
Completion of Snowpark DataFrame Programming or equivalent prior experience with DataFrame programming, including creation, transformation, and actions, as well as PySpark, UDFs, and stored procedures.
Prior experience with Snowflake accounts, roles, virtual warehouses, databases, tables, and views.
Previous knowledge and experience with data warehouse concepts.
Proficiency in writing Python code.
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

Module 1: Snowpark Review

What is Snowpark?

Snowpark use cases

Snowpark architecture

Snowpark setup

Module 2: DML Using Table DataFrames

DataFrames are immutable

Tables as mutable DataFrames

Creating a table

Deleting rows from a table

Updating rows in a table

Merging rows in a table

Understanding views

Module 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)

Module 4: Developing Stored Procedures

Lambda examples

Anonymous Python stored procedures

Calling stored procedures with CALL (anonymous procedures)

Using sproc(…) as a decorator

Authoring stored procedures using DDL

Module 5: Working with Snowsight Python Worksheets

Additional overhead and cost considerations

Steps for using Snowsight Python Worksheets

Testing handlers

Module 6: Python Vectorized UDFs

Proper testing practices

Creating and using non-vectorized UDFs

Testing non-vectorized UDFs and measuring performance

Creating and using vectorized UDFs

Module 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 UDFs

Invoking UDFs

Unstructured data best practices

Module 8: Logging Messages with Snowpark

Introduction to logging

Log entries vs. trace events

Event tables

Setting log levels

Logging from Snowpark objects

Emitting trace events

Querying log messages

Module 9: Introduction to Snowflake Notebooks

Creating a notebook

Notebook cell basics

Running notebook cells

Editing cells

Importing Python packages

Running SQL and Python cells

Module 10: Using pandas with Snowflake Notebooks

Snowflake Notebooks overview

Introduction to pandas on Snowflake

DOWNLOAD COURSE BROCHURE

Who is the instructor for this training?

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

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree