Note
This view is available starting with V4.4.1.
Purpose
This view displays the information about AI models of all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | YES | The tenant ID. |
| MODEL_ID | int(20) | NO | The unique identifier of the model. |
| NAME | varchar(128) | NO | The unique name of the model defined by the user. When you call an AI function or the DBMS_AI_SERVICE package, you can use this name. |
| TYPE | varchar(128) | NO | The type of the model. Valid values:
NoticeThe sparse vector model is 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 of 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