UDFs (User-Defined Functions)

.

Related Topics

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

• SQL Function Reference

.

Related Info

For a tutorial on writing user-defined SQL functions, see the following page:

• Getting Started with User-Defined SQL Functions (Snowflake Quickstarts)

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 the following languages for writing UDFs:

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

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

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

Next Topics:

• Overview of UDFs
• Secure UDFs
• SQL UDFs
• JavaScript UDFs
• Java UDFs