UDFs (User-Defined Functions)

.

Related Topics

• DDL for User-Defined Functions, External Functions, and Stored Procedures

• SQL Function Reference

User-defined functions (UDFs) let you extend the system to perform operations that are not available through the built-in, system-defined functions provided by Snowflake. Snowflake currently supports two types of UDFs, SQL and JavaScript:

• A SQL UDF evaluates an arbitrary SQL expression and returns either scalar or tabular results.

• A JavaScript UDF lets you use the JavaScript programming language to manipulate data and return either scalar or tabular results.

Next Topics:

• Overview of UDFs
• Secure UDFs
• SQL UDFs
• SQL UDTFs (User-Defined Table Functions)
• JavaScript UDFs
• JavaScript UDTFs (User-Defined Table Functions)