Alibaba Cloud MaxCompute¶
Supported authentication¶
- Username/password
Prerequisites¶
The following is required before connecting to MaxCompute in DataRobot:
- Alibaba Cloud MaxCompute account
- Alibaba Cloud MaxCompute project
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¶
-
By default, MaxCompute sets a 10000 row download limitation. To disable this limit, see the MaxCompute JDBC download control documentation.
-
For more information on the MaxCompute Java Database Connectivity (JDBC) driver, see the MaxCompute JDBC driver documentation.
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. |