Note
This view is available starting with V4.6.2.1.
Overview
Displays the AI vendor (Provider) configuration information for the current tenant, including the connection information and access credential configurations of vendors registered via REGISTER_PROVIDER.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| PROVIDER_NAME | varchar(256) | NO | Vendor name. In provider/model In the formula, / The name is displayed on the left. |
| PROTOCOL | varchar(256) | NO | Communication protocol, for example, openai, dashscope, cohere etc. |
| BASE_URL | varchar(2048) | NO | The currently effective base URL of the model service. |
| ACCESS_KEY | varchar(2048) | NO | Access credentials. The query results are not returned in plaintext. |
| CREATE_TIME | timestamp(6) | NO | Creation time. |
| UPDATE_TIME | timestamp(6) | NO | Last modified at. |
Sample query
Query the AI provider configuration information for the current tenant. If no provider configuration has been registered, execute REGISTER_PROVIDER first and replace access_key with the actual value.
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