3.9.5 Viewing Models

To view the models in your model catalog, query the MODEL_CATALOG table; for example: 

SELECT model_id, model_handle, model_owner FROM ML_SCHEMA_user1.MODEL_CATALOG;

where:

  • model_id is a unique numeric identifier for the model.

  • model_owner is the user that created the model.

  • model_handle is the handle by which the model is called.

  • ML_SCHEMA_user1.MODEL_CATALOG is the fully qualified name of the MODEL_CATALOG table. The schema is named for the owning user.

Note

The example above retrieves data from only a few MODEL_CATALOG table columns. For other columns you can query, see Section 3.9.1, “The Model Catalog”.