Quick BI:Add a MaxCompute Data Source

Limitations

Limitations

• Supports MaxCompute V1.0 and V2.0.

• Only workspace administrators and developers can add data sources.

Procedure

1. Log on to the Quick BI console.

2. To add a data source:

   1. Follow Create data source entry point to open the Create Data Source page.

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

      

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

   

   Parameter	Description
   Display name	Name shown in the data source list. Cannot contain special characters or leading/trailing spaces.
   Endpoint	Connection URL for the MaxCompute project. Use an internal endpoint to avoid public network fees. If the connection fails, adjust your allowlist settings. Select the internal endpoint for your project's region, shown 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	Name of the target MaxCompute project. Find this in the MaxCompute console under the Project Management tab for your region.
   Schema	Schema name for the connection. Required for three-layer model projects. Optional for two-layer models.
   AccessKey ID and AccessKey Secret	Credentials for an account authorized to access the MaxCompute project. The account must have CreateInstance and List permissions on the project, and Desc permission on tables. File uploads also require CreateTable and Write permissions. Obtain credentials from the RAM console.
   Computing quota group	If you use MaxQA query acceleration, enter the MaxQA quota group name. Defaults to MCQA 1.0 if left empty.
   Enable file upload entry	Select this option to allow file uploads.
   Initial SQL	When enabled, specified SQL statements run automatically after connection. Only SET statements are allowed. Separate multiple statements with semicolons (;).

4. Click Test Connection to verify the connection.

   

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 MaxCompute table lists. First-time additions may take 10–15 seconds to sync. Click Refresh to update.