CREATE FUNCTION and CREATE PROCEDURE: Signature size limit reduced (Pending)¶

Snowflake is decreasing the pre-validation threshold for CREATE FUNCTION and CREATE PROCEDURE statements. Statements are rejected when the combined size of the function name, parameter signature, and return type exceeds 9,800 bytes (previously 10,000 bytes).

Before the change:

Functions and procedures with very large signatures (for example, hundreds of parameters combined with long function names) can be created successfully. However, these objects can’t subsequently be managed: attempts to DROP, RENAME, or ALTER them fail with an internal error, leaving the objects permanently stuck in the account.

After the change:

CREATE FUNCTION and CREATE PROCEDURE statements that would produce a signature exceeding 9,800 bytes are rejected at creation time with error code 09024: “Function name (including parameter and return type) too long.”

This prevents the creation of functions and procedures that would be unmanageable after creation.

This limit only affects functions or procedures with unusually large signatures, such as those with hundreds of parameters combined with long names. Most CREATE FUNCTION and CREATE PROCEDURE statements are well under this limit.

If you have existing functions or procedures that are stuck and can’t be dropped or altered, contact Snowflake Support.

Ref: 2303