Note
This view is available starting with V4.4.1.
Purpose
This view displays the information about AI models in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| MODEL_ID | int(20) | NO | The unique ID of the model. |
| NAME | varchar(128) | NO | The unique name of the model. You can specify this name when you call an AI function or the DBMS_AI_SERVICE package. |
| TYPE | varchar(128) | NO | The type of the model. Valid values:
NoticeAt present, sparse vector models are not supported. |
| MODEL_NAME | varchar(128) | NO | The name of the model, for example, text-embedding-v2. |
Sample query
Query the information about AI models in the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_AI_MODELS;
The query result is as follows:
+----------+---------------+-----------------+-------------------+
| MODEL_ID | NAME | TYPE | MODEL_NAME |
+----------+---------------+-----------------+-------------------+
| 500005 | my_ai_model_1 | DENSE_EMBEDDING | text-embedding-v1 |
+----------+---------------+-----------------+-------------------+
1 row in set