# Alibaba Cloud MaxCompute
URL: https://docs.datarobot.com/en/docs/reference/data-ref/data-sources/wb-maxcompute.html

> How to connect to MaxCompute in DataRobot.

# 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 |

> [!TIP] 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](https://www.alibabacloud.com/help/en/maxcompute/user-guide/usage-notes-2#section-ue6-n1n-bpg) or the [aliyun-odps-jdbcpublic repository](https://github.com/aliyun/aliyun-odps-jdbc/tree/master?tab=readme-ov-file#connection-string-parameters).

## Feature considerations

- By default, MaxCompute sets a 10000 row download limitation. To disable this limit, see theMaxCompute JDBC download control documentation.
- For more information on the MaxCompute Java Database Connectivity (JDBC) driver, see theMaxCompute JDBC driver documentation.

### MaxCompute prediction considerations

When using MaxCompute for predictions:

- As a data destination, only the "insert"write strategyis 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](https://www.alibabacloud.com/help/en/maxcompute/user-guide/table-creation-and-deletion).

## 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. |

---
