Alibaba Cloud data source: MaxCompute

Limitations

• Supports MaxCompute versions 1.0 and 2.0.

• Only a workspace administrator or a developer can add a data source.

Procedure

1. Log on to the Quick BI console.

2. To add the data source:

   1. Go to the create data source page as described in Create Data Source.

   2. On the Alibaba Cloud Databases tab, select MaxCompute.

3. In the Configure Connection dialog box, set the following parameters.

   Parameter	Description
   Display Name	The display name for the data source in the data source list. Enter a valid name. The name cannot contain special characters or leading or trailing spaces.
   Database Address	The URL for connecting to the MaxCompute project. You can use a public endpoint or an internal endpoint. We recommend using an internal endpoint to avoid potential fees for public network traffic. If the connection fails, you may need to disable allowlist restrictions. Select the internal endpoint that corresponds to the region where your project is located. You can find the region in the upper-left corner of the MaxCompute console. For example, the internal endpoint for the China (Hangzhou) region is https://service.cn-hangzhou-intranet.maxcompute.aliyun-inc.com/api.
   Project Name	The name of the target MaxCompute project. Log on to the MaxCompute console. After you switch to the correct region in the upper-left corner, you can view the MaxCompute project name on the Project Management tab.
   Schema	Enter the name of the schema to connect to. If your MaxCompute project uses a three-layer model, you must specify a schema. If it uses a two-layer model, you do not need to specify a schema.
   AccessKey ID and AccessKey Secret	The AccessKey ID and AccessKey Secret with permissions to access the target MaxCompute project. Ensure that the account has CreateInstance, List, and table Desc permissions for the project. If you need to upload files, the account also requires the CreateTable and Write permissions. You can obtain the AccessKey ID and AccessKey Secret from the RAM console.
   Quota resource group	If you use the MaxQA query acceleration feature of MaxCompute, enter the name of the MaxQA Quota group. If you leave this field empty, Quick BI uses the MaxCompute MCQA 1.0 feature for query acceleration by default.
   Enable file upload entrance	If enabled, you can upload files. This option is enabled by default.
   Initialization SQL	If enabled, you can configure SQL statements to run immediately after Quick BI establishes a connection to the data source. Only SET statements are allowed. Separate multiple statements with a semicolon (;).

4. Click Test Connection to verify the connection.

   

   Note

   For information about data source permission control issues, see Solutions to common errors and permission control issues when connecting Quick BI to a MaxCompute data source.

5. If the connection test is successful, click OK to add the data source.

   The new data source appears in the data source list.

   Note

   Quick BI caches the table list for MaxCompute data sources. If you are adding this data source for the first time, you may need to wait 10 to 15 seconds for the table metadata to synchronize. To update the table list, click the Refresh button in the upper-right corner.