SHOW MODELS¶

Lists the machine learning models that you have privileges to access.

The output returns table metadata and properties, ordered lexicographically by database, schema, and model name (see Output in this topic for descriptions of the output columns). This is important to note if you wish to filter the results using the provided filters.

See also:: CREATE MODEL , DROP MODEL , ALTER MODEL, SHOW VERSIONS IN MODEL

Syntax¶

SHOW MODELS [ LIKE '<pattern>' ]
            [ IN { DATABASE [ <db_name> ] | SCHEMA [ <schema_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).

IN DATABASE [ db_name ] | SCHEMA [ schema_name ]

Optionally specifies the scope of the command, which determines whether the command lists models only in the current/specified database or schema.

If you specify the keyword ACCOUNT, then the command retrieves records for all schemas in all databases of the current account.

If you specify the keyword DATABASE, then:

If you specify a db_name, then the command retrieves records for all schemas of the specified database.
If you do not specify a db_name, then:
- If there is a current database, then the command retrieves records for all schemas in the current database.
- If there is no current database, then the command retrieves records for all databases and schemas in the account.

If you specify the keyword SCHEMA, then:

If you specify a qualified schema name (e.g. my_database.my_schema), then the command retrieves records for the specified database and schema.
If you specify an unqualified schema_name, then:
- If there is a current database, then the command retrieves records for the specified schema in the current database.
- If there is no current database, then the command displays the error SQL compilation error: Object does not exist, or operation cannot be performed.
If you do not specify a schema_name, then:
- If there is a current database, then:
  - If there is a current schema, then the command retrieves records for the current schema in the current database.
  - If there is no current schema, then the command retrieves records for all schemas in the current database.
- If there is no current database, then the command retrieves records for all databases and all schemas in the account.

Default: Depends on whether the session currently has a database in use:

Database: DATABASE is the default (i.e. the command returns the models you have privileges to view in the current database).
No database: Account scope is the default (i.e. the command returns the models you have privileges to view in your account).

Output¶

The command output provides table properties and metadata in the following columns:

Column	Description
created_on	Date and time when the model was created.
name	Name of the model.
database_name	Database in which the model is stored.
schema_name	Schema in which the model is stored.
owner	Role that owns the model.
comment	Comment for the model.
versions	JSON array listing versions of the model.
default_version_name	Version of the model used when referring to the model without a version.

Usage Notes¶

Results are sorted by database name, schema name, and then model name. This means results for a database can contain models from multiple schemas and might break pagination. In order for pagination to work as expected, you must execute the SHOW MODELS statement for a single schema. You can use the IN SCHEMA schema_name parameter to the SHOW MODELS command. Alternatively, you can use the schema in the current context by executing a USE SCHEMA schema_name before executing a SHOW TABLES statement.