Cortex Base Models are exposed as model objects in the automatically populated and daily-refreshed SNOWFLAKE.MODELS schema. Snowflake's SHOW MODELS command (syntax: SHOW MODELS [LIKE '<pattern>'] [IN {DATABASE [<db_name>] | SCHEMA [<schema_name>]}]) lists machine learning model objects a role can access, and the SCHEMA keyword can be omitted when a fully qualified schema name is supplied, making 'SHOW MODELS IN SNOWFLAKE.MODELS;' valid and exactly the command Snowflake's documentation recommends for verifying which Cortex models are currently available. The bare 'SHOW MODELS;' command is the same underlying command used without an explicit scope. The other options are not valid or not for listing: LS applies only to stages, 'SHOW VERSIONS ... IN MODEL LLM' references a nonexistent model object, and CALL SNOWFLAKE.MODELS.CORTEX_BASE_MODELS_REFRESH() only forces a manual refresh of the model catalog rather than displaying it.
Community Discussion