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 function was last altered.

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.

1(1,2,3,4,5)

These fields apply only to Écriture de fonctions externes.

Usage Notes

  • The view only displays objects for which the current role for the session has been granted an instance role with access privileges.

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