User-defined Functions (UDFs)

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 return 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: