Writing User-Defined Functions (UDFs)¶
With user-defined functions (UDFs), you can extend the system to perform operations that are not available through the built-in, system-defined functions provided by Snowflake.
The following topics provide more information on writing UDF handlers in the supported languages, as well as how to ensure UDFs execute securely.
- Overview of UDFs
Extend Snowflake to perform operations that are not available through built-in, system-defined functions.
- Granting Privileges for User-Defined Functions
Grant privileges required on objects so that they can perform specific SQL actions with a UDF or UDTF.
The following topics describe how you can write UDF handlers in various languages.
- Writing Java UDFs
Develop handlers in Java to manipulate data and return scalar or tabular results.
- Writing JavaScript UDFs
Develop handlers in JavaScript to manipulate data and return scalar or tabular results.
- Writing Python UDFs
Develop handlers in Python to manipulate data and return scalar or tabular results.
- Writing SQL UDFs
Develop handlers in SQL to evaluate an arbitrary SQL expression and return scalar or tabular results.