SHOW CORTEX BASE MODELS¶

Lists the Cortex Base Models available in your account, along with their lifecycle status, regional availability, legacy date, and end-of-life date.

Cortex Base Models are the LLMs that Snowflake provides for use with Cortex AI Functions and related features. Unlike SHOW MODELS, which lists all model objects (including user-created models), this command is scoped to Cortex Base Models and returns additional columns that describe each model’s lifecycle stage and availability. Use this command to determine which models are currently usable in your account.

See also:: SHOW MODELS

Syntax¶

SHOW CORTEX BASE MODELS
  IN [ SCHEMA ] SNOWFLAKE.MODELS
  [ LIKE '<pattern>' ]

Parameters¶

IN [ SCHEMA ] SNOWFLAKE.MODELS: Specifies the schema that contains the Cortex Base Model objects. Cortex Base Models are stored in the SNOWFLAKE.MODELS schema. This clause is required.

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

Output¶

The command output provides the following columns:

Column	Data type	Description
`name`	VARCHAR	Name of the Cortex Base Model.
`lifecycle_status`	VARCHAR	Current lifecycle stage of the model. Possible values: `GA`: Generally available. The model is fully supported and recommended for production use. `PUPR`: Public preview. The model is available to all accounts but may have limitations. See Snowflake Preview Features for details. `PRPR`: Private preview. The model is available to accounts that have been specifically enabled. `LEGACY`: The model has entered its legacy period. Using this model is not recommended. It will be removed from service on the date shown in `eol_date`. Migrate to a supported model before that date. `EOL`: End of life. The model is no longer available.
`available_regions`	ARRAY	List of Snowflake regions where the model is currently deployed, for example `["AWS_US_EAST_1", "AZURE_EASTUS2"]`. Models with `LEGACY` or `EOL` status have an empty array. For a complete list of region identifiers, see Models and regional availability for Cortex AI Functions. If your account is in a region not listed here, you can use cross-region inference to access the model.
`legacy_date`	DATE	The date on which the model enters or entered `LEGACY` status.
`eol_date`	DATE	The date on which the model reaches or reached `EOL` status and is removed from service. `NULL` if no end-of-life date has been set. Plan any migrations before this date.

Access control requirements¶

The output is filtered based on the user’s model RBAC grants. Only models for which the current role has been granted access appear in the results. For information about granting access to Cortex Base Models, see Model access and privileges.

Usage notes¶

This command returns only Cortex Base Models. To list all model objects in your account, including Cortex Base Models and user models, use SHOW MODELS.
A model that appears in the results with a region in available_regions may still be unavailable to invoke if your account is in a different region and cross-region inference is not enabled. See Cross-region inference.

The command doesn’t require a running warehouse to execute.
The command only returns objects for which the current user’s current role has been granted at least one access privilege.
The MANAGE GRANTS access privilege implicitly allows its holder to see every object in the account. By default, only the account administrator (users with the ACCOUNTADMIN role) and security administrator (users with the SECURITYADMIN role) have the MANAGE GRANTS privilege.

To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.

For example, you can use the pipe operator or RESULT_SCAN function to select specific columns from the SHOW command output or filter the rows.

When you refer to the output columns, use double-quoted identifiers for the column names. For example, to select the output column type, specify SELECT "type".

You must use double-quoted identifiers because the output column names for SHOW commands are in lowercase. The double quotes ensure that the column names in the SELECT list or WHERE clause match the column names in the SHOW command output that was scanned.

Examples¶

List all Cortex Base Models accessible to the current role:

SHOW CORTEX BASE MODELS IN SCHEMA SNOWFLAKE.MODELS;

List Cortex Base Models whose names contain claude:

SHOW CORTEX BASE MODELS IN SCHEMA SNOWFLAKE.MODELS LIKE '%claude%';