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.