Snowpark UDTFs, UDAFs, and Stored Procedures

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Snowpark offers powerful tools for developers to write custom code in the form of UDFs, UDTFs, UDAFs, and stored procedures, each of which is implemented using extremely powerful handlers. In this course, learn about Snowflake UDTFs and partitioning, register and invoke UDTFs, construct a UDTF to normalize denormalized JSON data, and implement stateful processing using the end_partition and init functions. Next, discover how to partition rows to sort within a partition using UDTFs, explore Snowflake UDAFs and UDAF handler class methods, perform aggregation operations, and implement UDAFs that use Python objects and user-defined classes. Finally, examine Snowflake stored procedures and differentiate them from UDFs, UDTFs, and UDAFs, as well as register and invoke stored procedures and write Python functions using the Snowpark APIs. Upon completion of this course, you will be able to outline and use snowpark UDTFs, UDAFs, and stored procedures.