Note
This view is available starting with V4.6.0 BP1.
Overview
Displays the AI provider configuration information for the current tenant, including the connection information and access credentials of providers registered through the REGISTER_PROVIDER statement.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| 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 for the current tenant. If no provider has been registered, you must register one first. Replace access_key with your actual access key.
CALL DBMS_AI_SERVICE.REGISTER_PROVIDER('deepseek', '{
"access_key": "sk-xxx"
}');
SELECT PROVIDER_NAME, PROTOCOL, BASE_URL
FROM oceanbase.DBA_OB_AI_MODEL_PROVIDERS
WHERE PROVIDER_NAME = 'deepseek';
The sample result is as follows:
PROVIDER_NAME PROTOCOL BASE_URL
deepseek openai https://api.deepseek.com
1 row in set