Overview
Displays the AI model information for all tenants.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | YES | Tenant ID. |
| MODEL_ID | int(20) | NO | Unique identifier of the large model. |
| NAME | varchar(128) | NO | The unique name of the user-defined large model. When calling AI functions/DBMS_AI_SERVICE When installing system packages, you can use this name. |
| TYPE | varchar(128) | NO | The type of the large language model. The value must be one of the following:
NoteThe sparse vector model is not currently supported. |
| MODEL_NAME | varchar(128) | NO | Larger model name, for example, text-embedding-v2. |
Sample query
Query the AI model information for 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