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”.