Skip to main content


Modifies an ML configuration.


ALTER ML CONFIGURATION ml-configuration-name
  [ PROVIDER provider-name] [ %DESCRIPTION description]
  [ USING json-object-string ] [ provider-connection-settings ]


ml-configuration-name The name for the ML configuration being altered.
PROVIDER provider-name A string specifying the name of a machine learning provider, where values are:
  • AutoML

  • H2O

  • DataRobot

  • PMML

%DESCRIPTION description Optional — String. A text description for the ML configuration. See details below.
USING json-object-string Optional — A JSON string specifying one or more key-value pairs; see details below.
provider-connection-settings Any additional settings, required for connection, that vary by the machine learning provider. See details below.


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.


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.


You must specify the following values to successfully connect to DataRobot:

  • URL [ = ] url-string — where url-string is the URL of a DataRobot endpoint.

  • APITOKEN [ = ] token-string — where token-string is your client API token to access the DataRobot AutoML server.

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.


The following SQL query edits an existing configuration named TestH2O to add a USING clause that the user wants used for every model being trained:


See Also

FeedbackOpens in a new tab