FUNCTION_ID

NUMBER

Internal/system-generated identifier for the UDF.

FUNCTION_NAME

VARCHAR

Name of the UDF.

FUNCTION_SCHEMA_ID

NUMBER

Internal/system-generated identifier for the schema of the UDF.

FUNCTION_SCHEMA

VARCHAR

Schema which the UDF belongs to.

FUNCTION_CATALOG_ID

NUMBER

Internal/system-generated identifier for the database of the UDF.

FUNCTION_CATALOG

VARCHAR

Database which the UDF belongs to.

FUNCTION_OWNER

VARCHAR

Name of the role that owns the UDF.

ARGUMENT_SIGNATURE

VARCHAR

Type signature of the UDF’s arguments.

DATA_TYPE

VARCHAR

Return value data type.

CHARACTER_MAXIMUM_LENGTH

NUMBER

Maximum length in characters of string return value.

CHARACTER_OCTET_LENGTH

NUMBER

Maximum length in bytes of string return value.

NUMERIC_PRECISION

NUMBER

Numeric precision of numeric return value.

NUMERIC_PRECISION_RADIX

NUMBER

Radix of precision of numeric return value.

NUMERIC_SCALE

NUMBER

Scale of numeric return value.

FUNCTION_LANGUAGE

VARCHAR

Language of the UDF.

FUNCTION_DEFINITION

VARCHAR

UDF definition.

VOLATILITY

VARCHAR

Whether the UDF is volatile or immutable.

IS_NULL_CALL

VARCHAR

Whether the UDF is called when input is null.

CREATED

TIMESTAMP_LTZ

Date and time when the UDF was created.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.

DELETED

TIMESTAMP_LTZ

Date and time when the UDF was dropped.

COMMENT

VARCHAR

Comment for the function.

IS_EXTERNAL [1]

VARCHAR(3)

YES if the function is an external function; otherwise, NO.

API_INTEGRATION [1]

VARCHAR

Name of the API integration object to authenticate the call to the proxy service.

CONTEXT_HEADERS [1]

VARCHAR

Context header information for the external function.

MAX_BATCH_ROWS [1]

NUMBER

Maximum number of rows in each batch sent to the proxy service.

COMPRESSION [1]

VARCHAR

Type of compression.

PACKAGES

VARCHAR

Packages requested by the function.

RUNTIME_VERSION

VARCHAR

Runtime version of the language used by the function. NULL if the function is SQL or JavaScript.

INSTALLED_PACKAGES

VARCHAR

All packages installed by the function. Output for Python functions only.

OWNER_ROLE_TYPE

VARCHAR

The type of role that owns the object, for example ROLE. . If a Snowflake Native App owns the object, the value is APPLICATION. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

IS_MEMOIZABLE

VARCHAR(3)

YES if the function is memoizable; otherwise, NO.

IS_DATA_METRIC

VARCHAR(3)

YES if the function is a data metric function; otherwise, NO.

SECRETS

JSON map

Map of secrets specified by the function’s SECRETS parameter, where map keys are secret variable names and map values are secret object names.

EXTERNAL_ACCESS_INTEGRATIONS

VARCHAR

Names of external access integrations specified by the function’s EXTERNAL_ACCESS_INTEGRATION parameter.

IS_AGGREGATE

VARCHAR(3)

YES if the function is an aggregate function; otherwise, NO.