MaxCompute:Connect DataGrip to MaxCompute

Prerequisites

Procedure

To connect DataGrip to MaxCompute, perform the following steps:

1. Step 1: Add a MaxCompute JDBC driver

   Upload the package of the MaxCompute JDBC driver to DataGrip. Then, DataGrip can use the driver to access the MaxCompute project.

2. Step 2: Connect DataGrip to MaxCompute

   Configure connection parameters to connect DataGrip to the MaxCompute project.

3. Step 3: Use DataGrip to manage the MaxCompute project

   Manage the MaxCompute project on DataGrip based on the established data connection.

Step 1: Add a MaxCompute JDBC driver

1. Start DataGrip.

2. Click New Project to create a project named MaxCompute_test.

3. On the page that appears, click the icon. In the Data Sources and Drivers dialog box, click the Drivers tab, add the JAR package of the MaxCompute JDBC driver, configure the Name and Class parameters, and then click Apply.

   In the Driver Files section, click the icon and select Custom JARs... to upload the JAR package of the MaxCompute JDBC driver, such as odps-jdbc-3.2.9-jar-with-dependencies.jar, from your on-premises machine.

   

   Parameter	Description
   Name	The name of the driver that you want to add, such as MaxCompute.
   Class	After the JAR package of the MaxCompute JDBC driver is uploaded, select com.aliyun.odps.jdbc.OdpsDriver from the Class drop-down list on the General tab.

Step 2: Connect DataGrip to MaxCompute

1. On the Data Sources tab of the Data Sources and Drivers dialog box, click the icon and select the MaxCompute data source.

   You can also click the Drivers tab in the Data Sources and Drivers dialog box and click Create Data Source to add the MaxCompute data source.

2. In the dialog box that appears, configure connection parameters. The following table describes the connection parameters.

   

   Parameter	Description
   Name	The name of the new data connection, which is used to distinguish the connections of different databases in the system. In this topic, set this parameter to MCtoDG.
   User	The AccessKey ID that is used to access the MaxCompute project. You can obtain the AccessKey ID on the AccessKey Pair page.
   Password	The AccessKey secret that corresponds to the AccessKey ID. You can obtain the AccessKey secret on the AccessKey Pair page.
   URL	The URL that is used to connect to the MaxCompute project. The format is jdbc:odps:<MaxCompute_endpoint>?project=<MaxCompute_project_name>[&interactiveMode={true|false}]. Delete the angle brackets (<>) when you configure this parameter. Parameters: <MaxCompute_endpoint>: required. The endpoint of MaxCompute. Configure this parameter based on the region where the MaxCompute project resides. For more information about the endpoints of MaxCompute in different regions, see Endpoints. <MaxCompute_project_name>: required. The name of the MaxCompute project. This parameter specifies the name of your MaxCompute project instead of the DataWorks workspace to which the MaxCompute project corresponds. You can log on to the MaxCompute console, select the region where your MaxCompute project resides in the top navigation bar, and then view the name of the MaxCompute project on the Project management tab. interactiveMode: optional. This parameter specifies whether to enable the MaxCompute Query Acceleration (MCQA) feature. If you want to enable the MCQA feature, add &interactiveMode=true to the end of the URL. For more information about the MCQA feature, see Query acceleration. useProjectTimeZone: optional. This parameter specifies whether to use the time zone. If you need to keep the time zone of DataGrip consistent with that of the MaxCompute server, append the &useProjectTimeZone=true configuration to the URL.

3. Click Test Connection. If the message shown in the following figure appears, click OK.

   

Step 3: Use DataGrip to manage the MaxCompute project