MODEL_VERSIONS view

This Information Schema view displays a row for each machine learning model version defined in the specified (or current) database.

Columns

Column NameData TypeDescription
DATABASE_NAMETEXTDatabase to which the model version belongs.
SCHEMA_NAMETEXTSchema to which the model version belongs.
MODEL_NAMETEXTModel to which the model version belongs.
MODEL_VERSION_NAMETEXTName of the model version.
VERSION_ALIASESARRAYList of aliases of the model version.
COMMENTTEXTComment for the model version.
OWNERTEXTName of the role that owns the model version.
CREATEDTIMESTAMP_LTZDate and time when model version was created.
LAST_ALTEREDTIMESTAMP_LTZDate and time when the model version was last updated.
FUNCTIONSTEXTFunctions in the model version.
MODEL_TYPETEXTType of the model to which the model version belongs.
PYTHON_VERSIONTEXTVersion of Python required by the model version.
LANGUAGETEXTLanguage in which the model version is implemented.
DEPENDENCIESTEXTDependencies of the model version.
METADATATEXTMetadata of the model version.
USERDATATEXTUser data of the model version.

Usage notes

  • The view only displays objects for which the current role for the session has been granted access privileges.
  • The view does not include model versions that have been dropped.

Examples

Retrieve the names of all model versions, functions, and the model they belong to, in the mydatabase database:

SELECT model_version_name, model_name, functions, schema_name, database_name
    FROM mydatabase.INFORMATION_SCHEMA.MODEL_VERSIONS;