User Defined Functions (UDFs in Snowflake) This concept should be familiar as it’s very similar to other RDBMSs. There are two primary types of functions in Snowflake:
Types of UDF Scalar function — returns one output value for each input value.
Tabular (table) function — returns a table of zero, one or many rows for each input row.
Ready to learn more? In this video I introduce you to user defined functions in Snowflake. Learn the differences between a scalar and table user defined function and how to apply them to solve real-world problems.