Modifies an ML configuration.
Description
The ALTER ML CONFIGURATION statement alters one, or several, parameters within an ML configuration definition. You can alter:
ML Configuration Description
%DESCRIPTION accepts a text string enclosed in single quotes, which you can use to provide a description for documenting your configuration. This text can be of any length, and can contain any characters, including blank spaces.
USING
You can specify a default USING clause for your configuration. This clause accepts a JSON string with one or more key-value pairs. When TRAIN MODEL is executed, by default the USING clause of the configuration is used.
ALTER ML CONFIGURATION MyConfiguration USING {"seed": 3}
You must make sure that the parameters you specify are recognized by the provider you select. Failing to do so may result in an error when training.
Provider Connection Settings
Depending on the provider specified by your configuration, there may be additional fields you must enter to establish a successful connection.
DataRobot
You must specify the following values to successfully connect to DataRobot:
Altering an ML configuration for DataRobot could be performed with a query as follows:
ALTER ML CONFIGURATION datarobot-configuration URL url-string APITOKEN token-string
With proper values for url-string and token-string
Required Security Privileges
Calling ALTER ML CONFIGURATION requires %ALTER_ML_CONFIGURATION privileges; otherwise, there is a SQLCODE –99 error (Privilege Violation). To assign %ALTER_ML_CONFIGURATION privileges, use the GRANT command.