UDF (User-Defined Function) & Stored Procedure DDL

UDFs (user-defined functions) and stored procedures are two programming constructs that allow you to extend Snowflake SQL.

In this Topic:

UDF Management

UDFs can be used to perform operations that are not available via the system-defined functions provided by Snowflake. Snowflake provides the following DDL commands for creating and managing UDFs:

Note

UDFs can contain SQL or JavaScript; however, DDL and DML operations are not supported in UDFs.

Stored Procedure Management & Usage

Snowflake provides the following DDL commands for creating and managing stored procedures:

In addition, Snowflake provides the following command for using stored procedures: