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

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:

• CREATE FUNCTION

• ALTER FUNCTION

• DROP FUNCTION

• DESCRIBE FUNCTION

• SHOW USER FUNCTIONS

External Function Management¶

External functions can be used to perform operations that are not available via the system-defined functions provided by Snowflake. External functions are a type of UDF, but their syntax is different enough that they have their own CREATE, ALTER, and SHOW statements.

Snowflake provides the following DDL commands for creating and managing external functions:

• CREATE EXTERNAL FUNCTION

• ALTER FUNCTION

• DROP FUNCTION

• SHOW EXTERNAL FUNCTIONS

• DESCRIBE FUNCTION

External functions use API integrations. Snowflake provides the following DDL commands for creating and managing API integrations:

• CREATE API INTEGRATION

• ALTER API INTEGRATION

• DROP INTEGRATION

• SHOW INTEGRATIONS

• DESCRIBE INTEGRATION

Stored Procedure Management¶

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

• CREATE PROCEDURE

• ALTER PROCEDURE

• DROP PROCEDURE

• SHOW PROCEDURES

• DESCRIBE PROCEDURE

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

• CALL