Snowpark for Data Engineers

Focused View

Janani Ravi

1:51:11

0 View

01 - Introduction

01 - Snowpark for data engineers.mp4

05:30

02 - Prerequisites.mp4

00:39

02 - 1. Snowpark Handlers in Python Worksheets

01 - Getting set up with Snowflake.mp4

04:52

02 - Writing our first Snowpark handler.mp4

03:59

03 - Returning a table from the Snowpark handler.mp4

02:35

04 - Transformation with Snowpark data frames.mp4

03:06

05 - Reading files from a stage.mp4

04:30

06 - Defining multiple functions in a Python worksheet.mp4

03:04

07 - Installing Anaconda packages in a session.mp4

02:18

08 - Accessing custom packages from a stage.mp4

02:30

03 - 2. Using Snowpark DataFrames

01 - Using Snowpark from a locally running Jupyter Notebook.mp4

05:31

02 - Data transformations using Snowpark DataFrames.mp4

02:03

03 - Performing union operations on DataFrames.mp4

02:37

04 - Performing joins.mp4

03:29

05 - Creating views.mp4

04:04

06 - Working with semi-structured data.mp4

03:15

04 - 3. Working with UDFs

01 - UDFS, UDTFs, and Stored procedures.mp4

04:39

02 - Creating anonymous UDFs in Snowpark.mp4

04:16

03 - Creating named UDFs in Snowpark.mp4

03:21

04 - Accessing external packages in AUDF.mp4

02:18

05 - Understanding temporary UDFs.mp4

05:55

06 - Creating and invoking permanent UDFs.mp4

02:53

05 - 4. Working with UDTFs

01 - Creating and registering a UDTF.mp4

06:42

02 - Invoking a UDTF in Python and SQL.mp4

02:59

03 - Creating a table and uploading data.mp4

02:40

04 - Implementing a full-fledged UDTF.mp4

05:26

05 - Invoking UDTFs with different arguments.mp4

01:36

06 - 5. Working with Stored Procedures

01 - Creating and registering stored procedures.mp4

05:09

02 - Creating parameterized stored procedures.mp4

02:19

03 - Stored procedures with loops and conditional logic.mp4

02:10

04 - Deploying a stored procedure.mp4

03:12

07 - Conclusion

01 - Summary and next steps.mp4

01:34

Description

Take a deep dive into Snowpark Python in Snowflake, the library set specifically designed for data engineers and professionals seeking to leverage the capabilities of the Snowflake managed data platform. Join instructor Janani Ravi as she shows how to get up and running with Snowpark, from setting up a Snowflake trial account to writing Snowpark handlers, performing data transformations, and working with both structured and semistructured data. Along the way, explore more advanced concepts such as creating and managing user-defined functions (UDFs), user-defined table functions (UDTFs), and stored procedures, as well as how to install necessary packages, access custom packages, and connect to Snowflake from a Jupyter notebook. By the end of this course, you’ll be prepared to start manipulating data frames, performing data engineering tasks, and implementing complex data processing functions within Snowflake.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Janani Ravi

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.