Note
This view is available starting with V4.4.1.
Purpose
This view displays the information of AI models in all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | YES | The tenant ID. |
| MODEL_ID | int(20) | NO | The unique ID of the model. |
| NAME | varchar(128) | NO | The unique name of the model defined by the user. You can use this name to call an AI function or the DBMS_AI_SERVICE package. |
| TYPE | varchar(128) | NO | The type of the model. Valid values:
NoticeCurrently, sparse vector models are not supported. |
| MODEL_NAME | varchar(128) | NO | The name of the model. Example: text-embedding-v2. |
Sample query
Query the information of AI models in all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_AI_MODELS;
The query result is as follows:
+-----------+----------+---------------+-----------------+-------------------+
| TENANT_ID | MODEL_ID | NAME | TYPE | MODEL_NAME |
+-----------+----------+---------------+-----------------+-------------------+
| 1004 | 500005 | my_ai_model_1 | DENSE_EMBEDDING | text-embedding-v1 |
+-----------+----------+---------------+-----------------+-------------------+
1 row in set