Snowpark pandas and User-defined Functions

Snowflake    |    Expert
  • 9 videos | 1h 20m 1s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
DataFrames are the core Snowpark table abstraction. Snowpark supports the Snowpark pandas API and its DataFrames, as well as the rich functionality related to user-defined functions (UDFs). In this course, learn how to work with the Snowpark pandas API, create Snowflake Notebooks, use Snowpark pandas via the Modin plugin, and convert between Snowpark pandas and Snowpark DataFrame objects. Next, explore Snowflake UDFs, UDAFs, UDTFs, and stored procedures. Finally, discover how to register and invoke permanent and anonymous UDFs in Snowflake and register UDFs from SQL and Python files. After completing this course, you will be able to use Snowpark pandas DataFrames and register and invoke user-defined functions (UDFs).

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Outline the snowpark pandas api and contrast it with pandas and snowpark
    Create a snowflake notebook and use snowpark pandas via the modin plugin
    Convert snowpark pandas and snowpark dataframe objects and contrast their behaviors
    Outline udfs, udtfs, udafs, and stored procedures and compare and contrast them
  • Register anonymous udfs using the udf function and session.udf.register, and invoke them using call_udf
    Register permanent udfs using the @udf decorator and then invoke them from different sessions
    Register udfs from sql and python files
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 44s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 11m 26s
    After completing this video, you will be able to outline the Snowpark pandas API and contrast it with pandas and Snowpark. FREE ACCESS
  • Locked
    3.  Using Snowpark pandas and Snowflake Notebooks
    11m 34s
    During this video, discover how to create a Snowflake Notebook and use Snowpark pandas via the Modin plugin. FREE ACCESS
  • Locked
    4.  Converting and Contrasting Snowpark pandas and Snowpark DataFrames
    12m 8s
    Upon completion of this video, you will be able to convert Snowpark pandas and Snowpark DataFrame objects and contrast their behaviors. FREE ACCESS
  • Locked
    5.  User-defined Functions in Snowpark
    8m 22s
    In this video, we will outline UDFs, UDTFs, UDAFs, and stored procedures and compare and contrast them. FREE ACCESS
  • Locked
    6.  Registering and Invoking Anonymous UDFs
    11m 57s
    Find out how to register anonymous UDFs using the udf function and session.udf.register, and invoke them using call_udf. FREE ACCESS
  • Locked
    7.  Registering and Invoking Permanent UDFs
    10m 33s
    In this video, discover how to register permanent UDFs using the @udf decorator and then invoke them from different sessions. FREE ACCESS
  • Locked
    8.  Using SQL and Python Files to Register UDFs
    10m 31s
    During this video, you will learn how to register UDFs from SQL and Python files. FREE ACCESS
  • Locked
    9.  Course Summary
    1m 48s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Continuous Data: Ingesting Continuous Data in Snowflake
Rating 4.8 of 33 users Rating 4.8 of 33 users (33)
Course CompTIA Data+: Data Visualization Dashboards
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
Course Data Loading in Snowflake: Fundamentals of Stages
Rating 4.7 of 50 users Rating 4.7 of 50 users (50)