The ALTER_PROVIDER procedure is used to modify the configuration of an AI provider created within a tenant.
Notice
This procedure is supported starting from V4.6.0 BP1.
Syntax
PROCEDURE alter_provider(
IN provider_name VARCHAR(256),
IN json_params JSON);
Parameters
Parameter |
Description |
Type |
Value range |
Nullable |
|---|---|---|---|---|
| provider_name | Provider name. | VARCHAR(256) | Up to 256 bytes | NO |
| json_params | Provider configuration, which must be a JSON object. | JSON | See the following table | NO |
The json_params parameter supports the following fields:
field |
Type |
Description |
|---|---|---|
base_url |
VARCHAR(2048) | The currently effective base URL. |
access_key |
VARCHAR(2048) | Access credentials, which are stored in encrypted form when writing to internal tables. |
Notice
Modifying the protocol is not currently supported. To use a different protocol, please register a new provider.
Examples
Modify access_key:
CALL DBMS_AI_SERVICE.ALTER_PROVIDER('aliyun', '{
"access_key": "sk-1xxxx"
}');
Modify the built-in provider's base_url to the Alibaba Cloud international endpoint:
CALL DBMS_AI_SERVICE.ALTER_PROVIDER('aliyun', '{
"base_url": "https://dashscope-intl.aliyuncs.com/compatible-mode/v1"
}');