Quick BI:Add a MaxCompute Data Source

Limits

Versions 1.0 and 2.0 are supported.

Limits

• Versions 1.0 and 2.0 are supported.

• Only workspace administrators and developers can add data sources.

Procedure

1. Log on to the Quick BI console.

2. Add a data source as shown in the following figure:

   1. Go to the Create Data Source page from the entry for creating a data source.

   2. On the Alibaba Cloud Database tab, select MaxCompute data source.

      

3. In the Configure Connection dialog box, complete the following configurations.

   Name	Description
   Display Name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
   Database Address	The URL used to connect to the MaxCompute project. You can use a public network or cloud product interconnection. We recommend that you use the "Cloud Product Interconnection Endpoint" (if the network is not connected, you need to disable the whitelist restriction) to avoid additional costs that may be incurred when accessing through the public network. Select the corresponding "Cloud Product Interconnection Endpoint" based on the region where your project is located (you can check the region by clicking the upper-left corner after logging in to the MaxCompute console). For example, the "Cloud Product Interconnection Endpoint" for China (Hangzhou) is https://service.cn-hangzhou-intranet.maxcompute.aliyun-inc.com/api.
   Project Name	The name of the MaxCompute project. Log on to the MaxCompute console, switch to the appropriate region in the upper-left corner, and then you can view the specific MaxCompute project name on the Project Management tab.
   Schema	Enter the name of the schema you want to connect to. If your MaxCompute uses a 3-layer model, you need to fill in the Schema. If it uses a 2-layer model, you do not need to fill it in.
   AccessKey ID and AccessKey Secret	The AccessKey pair of your Alibaba Cloud account that is used to access the MaxCompute project. Make sure that the account has the CreateInstance, List permissions for the project and the Desc permission for tables. If you need to upload files, the account must also have the CreateTable and Write permissions for the project. Log on to the RAM console to obtain the AccessKey ID and AccessKey Secret.
   Quota Computing Resource Group	If you use the MaxQA query acceleration feature of MaxCompute, enter the MaxQA Quota group name. If you leave this field empty, the MaxCompute MCQA 1.0 feature is used for query acceleration by default.
   Enable File Upload Entry	After this option is enabled, you can upload files.
   Init SQL	After this option is enabled, you can configure SQL statements that are executed for initialization after the data source is connected. The SQL statements that are executed for initialization each time the data source is connected. Only SET statements are allowed. Separate statements with semicolons.

4. Click Test Connection to test the connectivity of the data source.

   

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

   After the data source is added, you can view the data source in the data source list.

   Note

   For MaxCompute data sources, Quick BI caches the table list. If you add the data source for the first time, wait 10 to 15 seconds for data synchronization. To update the table list, you can click the Refresh button in the upper-right corner.