Configure MaxCompute Studio to Access Project Data via IntelliJ IDEA - MaxCompute

Prerequisites

Before you begin, ensure that you have:

Installed MaxCompute Studio
An AccessKey ID and AccessKey Secret for the Alibaba Cloud account or RAM user that has access to the MaxCompute project
The name of the MaxCompute project and its endpoint

For MaxCompute Studio configuration options, see Configure MaxCompute Studio.

Step 1: Create a MaxCompute Studio project

Open IntelliJ IDEA. In the menu bar, choose File > New > Project.
In the New Project dialog box, select MaxCompute Studio in the left pane, then click Next.
Enter a Project name and click Finish.

If another project is already open, IntelliJ IDEA asks whether to open the new project in a new window or the current one. Click This Window to reuse the current window.

Step 2: Connect to a MaxCompute project

In the menu bar, choose View > Tool Windows > Project Explorer.
In the upper-left corner of the Project Explorer panel, click + and select Add project from accessId/Key.

In the Add MaxCompute project dialog box, configure the connection on the Connection tab.

Two configuration methods are available:

Option A: Use a configuration file

Set Properties File to the directory where odps_config.ini (the MaxCompute client configuration file) is saved. This automatically populates Access Id, Access Key, Project Name, and End Point. For setup instructions, see Install and configure the MaxCompute client.

Alternatively, set AK Account to an existing Alibaba Cloud account. Click + to select an account from the Accounts page. If no accounts exist, click +, select Aliyun Account By AccessKey, and add one manually or via the configuration file. For details, see Accounts configuration items.

Click the icon in the lower-left corner of the Connection tab to open the online documentation.

Option B: Enter credentials manually

Parameter	Description	Default
Access Id	The AccessKey ID for the Alibaba Cloud account or RAM user connecting to the project	Required
Access Key	The AccessKey Secret for the account	Required
Project Name	The MaxCompute project name (not the DataWorks workspace name). To find it, log in to the MaxCompute console, select a region, and go to Workspace > Projects.	Required
End Point	The endpoint for the region where the project resides. Use the public endpoint if you are connecting from a machine outside the Alibaba Cloud internal network.	Required

Click OK. The Project Explorer panel displays the project's tables, views, UDFs, and resources.

If the connection times out, click the Setting tab and adjust the timeout values:

Parameter Description Default

sync one table timeout(s) Timeout for table synchronization 5 seconds

sync one function timeout(s) Timeout for function synchronization 30 seconds

Parameter	Description	Default
sync one table timeout(s)	Timeout for table synchronization	5 seconds
sync one function timeout(s)	Timeout for function synchronization	30 seconds

Step 3: Modify a connection

In Project Explorer, right-click the MaxCompute project and select Modify project properties.
In the Modify MaxCompute project dialog box, update the connection settings.

What's next

After connecting, you can:

Manage and view project data — browse tables, views, UDFs, and resources
Write and run SQL scripts — develop SQL programs in MaxCompute Studio
Write and run Java programs — develop Java programs in MaxCompute Studio
Write and run Python programs — develop Python programs in MaxCompute Studio

Troubleshooting

`ODPS-0420111: Project not found` or `Authorization Failed [4002]`

The full error messages look like:

Test connection fail: ODPS-0420111: Project not found - '<project_name>'.

Test connection fail:ODPS-0130013:Authorization exception-Authorization Failed [4002], You don't exist in project <project_name>. Context ID:<context ID>. --->Tips: Pricipal:ALIYUN$<account_name> | RAM$[<account_name>:]<RAM user name>;

If the project name is wrong: Log in to the MaxCompute console, select the region, go to Workspace > Projects, and copy the exact project name. Update the Project Name field with the correct value.

If the account is not a project member: The project owner must add the account before it can connect. See Add an Alibaba Cloud account (project-level) or Add a RAM user (project-level).

`connect timed out` — wrong endpoint

Test connection fail: connect timed out, the possible reason is that the endpoint '<endpoint>' is wrong, please check your endpoint

The End Point value doesn't match your network environment. For example, if you're connecting over the internet but entered an internal network endpoint, the connection will time out. Set End Point to the endpoint that matches both the project's region and your network environment. Get the correct value from Endpoints.

`The specified project or table name is not valid or missing`

Test connection fail: The specified project or table name is not valid or missing.

The End Point is set to a MaxCompute Tunnel endpoint, which is used for data transfer, not for project connections. Set End Point to the standard MaxCompute endpoint for your region and network environment. Get the correct value from Endpoints.