CLASS_INSTANCE_FUNCTIONS view¶

This Information Schema view displays a row for each function in a class instance.

See also:: CLASS_INSTANCES view, CLASS_INSTANCE_PROCEDURES view, SHOW FUNCTIONS

Columns¶

Column Name	Data Type	Description
FUNCTION_NAME	TEXT	Name of the function.
FUNCTION_INSTANCE_NAME	TEXT	Name of the class instance to which the function belongs.
FUNCTION_INSTANCE_SCHEMA	TEXT	Name of the schema to which the class instance belongs.
FUNCTION_INSTANCE_DATABASE	TEXT	Name of the database to which the class instance belongs.
FUNCTION_OWNER	TEXT	Name of the role that owns the function.
ARGUMENT_SIGNATURE	TEXT	Type signature of the function’s arguments.
DATA_TYPE	TEXT	Data type of the return value.
CHARACTER_MAXIMUM_LENGTH	NUMBER	Maximum length in characters of string type return value.
CHARACTER_OCTET_LENGTH	NUMBER	Maximum length in bytes of string type return value.
NUMERIC_PRECISION	NUMBER	Numeric precision of numeric type return value.
NUMERIC_PRECISION_RADIX	NUMBER	Radix of precision of numeric type return value.
NUMERIC_SCALE	NUMBER	Scale of numeric type 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	‘YES’ if the function is called on null input.
IS_SECURE	TEXT	‘YES’ if the function is secure.
CREATED	TIMESTAMP_LTZ	Date and time when the function 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.
COMMENT	TEXT	Comment for this function.
IS_EXTERNAL [1]	TEXT	‘YES’ if the function is an external function.
API_INTEGRATION [1]	TEXT	Name of the API integration object to authenticate the call to the proxy service.
CONTEXT_HEADERS [1]	TEXT	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]	TEXT	Type of compression.
PACKAGES	TEXT	Packages requested by the function.
RUNTIME_VERSION	TEXT	Runtime version of the language used by the function. NULL if the function is SQL or JavaScript.
INSTALLED_PACKAGES	TEXT	All packages installed by the function. Output for Python functions only.
IS_MEMOIZABLE	TEXT	‘YES’ if the function is memoizable, ‘NO’ otherwise.

Usage notes¶

The view only displays objects for which the current role for the session has been granted an instance role with access privileges.
The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- DML operations (for tables only). This column is updated even when no rows are affected by the DML statement.
- Background maintenance operations on metadata performed by Snowflake.

Examples¶

Retrieve the functions for class instances in the mydatabase database:

SELECT function_name,
       function_instance_name AS instance_name,
       argument_signature,
       data_type AS return_value_data_type
    FROM mydatabase.INFORMATION_SCHEMA.CLASS_INSTANCE_FUNCTIONS;

Copy