Writing User-Defined Functions (UDFs)

.

Related Topics

• SQL Function Reference

• Protecting Sensitive Information with Secure UDFs and Stored Procedures

.

Related Info

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

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

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.