3.14.5 Viewing Models

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

mysql> 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.14.1, “The Model Catalog”.