Skip to content

Alibaba Cloud MaxCompute

Supported authentication

  • Username/password

Prerequisites

The following is required before connecting to MaxCompute in DataRobot:

Required parameters

The table below lists the minimum required fields to establish a connection with MaxCompute:

Required field Description Documentation
address The service endpoint used to connect to Alibaba Cloud MaxCompute.

Example:
http://service.us-east-1.maxcompute.aliyun.com/api
Alibaba Cloud MaxCompute endpoint documentation
project The MaxCompute project for storing data.

Example:
my_maxcompute_project
Alibaba Cloud MaxCompute project documentation

Use a JDBC URL

You can also choose to use a JDBC URL to connect to MaxCompute. DataRobot notifies you about required parameters, but you can create a connection without them. The JDBC URL template is jdbc:odps:<maxcompute_endpoint>?project=<maxcompute_project_name>. For example, jdbc:odps:http://service.us-east-1.maxcompute.aliyun.com/api?project=jdbc_project&enableLimit=false. For more information on the available parameters, see the Alibaba Cloud MaxCompute JDBC parameters documentation or the aliyun-odps-jdbc public repository.

Feature considerations

MaxCompute prediction considerations

When using MaxCompute for predictions:

  • As a data destination, only the "insert" write strategy is supported. The writeback table and column names cannot contain special characters. These names can contain letters, digits, and underscores (_); however, they must start with a letter and cannot exceed 128 bytes in length. If the table and column names don't meet the requirements, an error is returned.

  • As a data source, the scoring data column names must be lowercase and cannot contain special characters. These names can contain letters, digits, and underscores (_); however, they must start with a letter and cannot exceed 128 bytes in length. If the column names don't meet the requirements, an error is returned.

For more information on table creation and requirements in MaxCompute, see the MaxCompute SQL table documentation.

Troubleshooting

Problem Solution Instructions
When attempting to execute an operation in DataRobot, the firewall requests that you clear the IP address each time. Add all allowed IPs for DataRobot. See Allowed source IP addresses. If you've already added the allowed IPs, check the existing IPs for completeness.