CLASS_INSTANCE_FUNCTIONS View¶
This Information Schema view displays a row for each function in a class instance.
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. 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).
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;