SHOW FUNCTIONS IN MODEL

Lists functions defined in machine learning models.

For more information, see Snowflake Model Registry.

See also:

SHOW FUNCTIONS , SHOW MODELS , SHOW VERSIONS IN MODEL

Syntax

SHOW FUNCTIONS [ LIKE '<pattern>' ] IN MODEL <model_name>
               [ VERSION <version_name> ]
Copy

Parameters

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...
... LIKE '%TESTING%' ...

. Default: No value (no filtering is applied to the output).

MODEL model_name, . MODEL model_name VERSION version_name

Returns records for the specified version (version_name) of the specified machine learning model (model_name).

If a version is not specified, records are displayed for the model’s default version.

Output

The SHOW FUNCTIONS IN MODEL command output provides function properties and metadata in the following columns:

Column

Description

created_on

The timestamp at which the function was created.

name

The function’s name.

version_name

The name of the model version that the function belongs to.

min_num_arguments

The minimum number of arguments to the function.

max_num_arguments

The maximum number of arguments to the function.

arguments

The data types of the arguments as a JSON-formatted string.

return_type

The data type of the return value.

description

Description of the function.

language

The language in which the function was written, such as “PYTHON”.