QuestionQ69

Snowflake Gen AI & LLM Functions

Which commands can be used to display the Snowflake Cortex LLM models that are available?

Choose two
  • A SHOW MODELS;
  • B LS @SNOWFLAKE.CORTEX.LLM;
  • C SHOW MODELS IN SNOWFLAKE.MODELS;
  • D SHOW VERSIONS LIKE 'CORTEX' IN MODEL LLM;
  • E CALL SNOWFLAKE.MODELS.CORTEX_BASE_MODELS_REFRESH();
Explanation

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.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!