Schema:
ACCOUNT_USAGE

FUNCTIONS View

This Account Usage view displays a row for each user-defined function (UDF) defined in the account.

For more information about UDFs, see UDFs (User-Defined Functions).

Columns

Column Name Data Type Description
FUNCTION_ID NUMBER Internal/system-generated identifier for the UDF.
FUNCTION_NAME TEXT Name of the UDF.
FUNCTION_SCHEMA_ID NUMBER Internal/system-generated identifier for the schema of the UDF.
FUNCTION_SCHEMA TEXT Schema which the UDF belongs to.
FUNCTION_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the UDF.
FUNCTION_CATALOG TEXT Database which the UDF belongs to.
FUNCTION_OWNER TEXT Name of the role that owns the UDF.
ARGUMENT_SIGNATURE TEXT Type signature of the UDF’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 UDF.
FUNCTION_DEFINITION TEXT UDF definition.
VOLATILITY TEXT Whether the UDF is volatile or immutable.
IS_NULL_CALL TEXT 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 when the UDF was last altered.
DELETED TIMESTAMP_LTZ Date and time when the UDF was dropped.
COMMENT TEXT Comment for the function.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).
  • The view only displays objects for which the current role for the session has been granted access privileges.
  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.