Note
This view is available starting with V4.6.0 BP1.
Overview
Displays the AI provider configuration information for all tenants. In the sys tenant, this view is commonly used to view the connection information and access credentials of providers registered by each tenant through the REGISTER_PROVIDER statement.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | YES | Tenant ID. |
| PROVIDER_NAME | varchar(256) | NO | Provider name. In the provider/model format, this is the value before /. |
| PROTOCOL | varchar(256) | NO | Communication protocol, for example, openai, dashscope, or cohere. |
| BASE_URL | varchar(2048) | NO | The currently effective base URL of the model service. |
| ACCESS_KEY | varchar(2048) | NO | Access credentials. Query results do not display the value in plaintext. |
| CREATE_TIME | timestamp(6) | NO | Creation time. |
| UPDATE_TIME | timestamp(6) | NO | Last modification time. |
Sample query
Query the AI provider configuration information of all tenants from the sys tenant.
Register a provider in user tenant
1004(replaceaccess_keywith the actual value):CALL DBMS_AI_SERVICE.REGISTER_PROVIDER('deepseek', '{ "access_key": "sk-xxx" }');Query in the sys tenant:
SELECT TENANT_ID, PROVIDER_NAME, PROTOCOL, BASE_URL FROM oceanbase.CDB_OB_AI_MODEL_PROVIDERS WHERE PROVIDER_NAME = 'deepseek';The sample result is as follows:
TENANT_ID PROVIDER_NAME PROTOCOL BASE_URL 1004 deepseek openai https://api.deepseek.com 1 row in set