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. |
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.