FUNCTIONS View¶

This Information Schema view displays a row for each user-defined function (UDF) or external function defined in the specified (or current) database.

For more information about external functions, see Writing External Functions. For more information about UDFs, see User-Defined Functions Overview.

Columns¶

Column Name	Data Type	Description
FUNCTION_CATALOG	TEXT	Database which the function belongs to
FUNCTION_SCHEMA	TEXT	Schema which the function belongs to
FUNCTION_NAME	TEXT	Name of the function
FUNCTION_OWNER	TEXT	Name of the role that owns the function
ARGUMENT_SIGNATURE	TEXT	Type signature of the function’s arguments
DATA_TYPE	TEXT	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	TEXT	Language of the function
FUNCTION_DEFINITION	TEXT	Function definition
VOLATILITY	TEXT	Whether the function is volatile or immutable
IS_NULL_CALL	TEXT	Whether the function is called on null input
IS_SECURE	BOOLEAN	True if the function is secure.
CREATED	TIMESTAMP_LTZ	Creation time of the function
LAST_ALTERED	TIMESTAMP_LTZ	Last altered time of the function
COMMENT	TEXT	Comment for this function
IS_EXTERNAL 1	BOOLEAN	True if the function is an external function.
API_INTEGRATION 1	VARCHAR	The name of the API integration object to authenticate the call to the proxy service.
CONTEXT_HEADERS 1	OBJECT	The context header information for the external function.
MAX_BATCH_ROWS 1	NUMBER	The maximum number of rows in each batch sent to the proxy service.
COMPRESSION 1	STRING	The type of compression.
PACKAGES	STRING	Packages requested by the function.
RUNTIME_VERSION	STRING	Runtime version of the language used by the function. NULL if the function is SQL or JavaScript.
INSTALLED_PACKAGES	STRING	All packages installed by the function. Output for Python functions only.
IS_MEMOIZABLE	TEXT	Yes if the function is memoizable, no otherwise. For details, see the usage notes.

1(1,2,3,4,5): These fields apply only to Writing External Functions.

Usage Notes¶

The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently might show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.

The IS_MEMOIZABLE column is not included in the output when the 2022_08 behavior change release bundle is disabled.

For information on disabling behavior change release bundles, see Behavior Change Management.