MaxCompute:Connect DataGrip to MaxCompute

Prerequisites

Procedure

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, 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 click the profile picture in the upper-right corner of the MaxCompute console and select AccessKey Management to obtain the AccessKey ID.
   Password	The AccessKey secret that corresponds to the AccessKey ID. You can click the profile picture in the upper-right corner of the MaxCompute console and select AccessKey Management to obtain the AccessKey secret.
   URL	The Uniform Resource Locator (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 to which you want to connect Tableau. 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.

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

Step 3: Use DataGrip to manage the MaxCompute project