All Products
Search
Document Center

Quick BI:Add a MaxCompute Data Source

Last Updated:Jan 25, 2024

After you add a MaxCompute data source to connect MaxCompute to Quick BI, you can analyze and view data in the Quick BI console. Quick BI can access MaxCompute over the Internet. This topic describes how to add a MaxCompute data source.

Prerequisites

A MaxCompute project is created. For more information, see Create a MaxCompute project.

Background information

If you are using an Alibaba Cloud MaxCompute data warehouse, you can add a MaxCompute data source when you connect to the Quick BI for data analysis. For more information about MaxCompute, see What is MaxCompute?

Limits

Only workspace administrators and developers can add data sources.

Procedure

  1. After you log on to the Quick BI console.

  2. Follow the instructions in the following figure to add a data source

    1. Go to the Create Data Source page.

    2. Select Alibaba MaxCompute.

      image

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

    Item

    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 that is used to connect to the MaxCompute project over the Internet or classic network. We recommend that you use a classic network connection (if the network is not connected, you must disable the whitelist limit) to improve the connection speed and avoid additional fees that may be incurred in Internet access.

    Select the corresponding classic network endpoint based on the region where the project is located. For more information about the region, click in the upper-left corner. For example, the corresponding classic network endpoint for China (Hangzhou) is http://service.cn-hangzhou.maxcompute.aliyun-inc.com/api.

    Project Name

    The name of the MaxCompute project.

    Log on to the MaxCompute console. Switch the region in the upper-left corner. Then, you can view the name of the MaxCompute project on the Project Management tab.

    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 Createlnstance, List, and Desc permissions on the project. If you want to upload objects, you must also have the CreateTable and Write permissions on the project. Log on to the RAM console and obtain the AccessKey ID and AccessKey secret.

    MaxCompute Query Acceleration

    Specifies whether to enable the MaxCompute Query Acceleration (MCQA) feature.

    If you want to enable the MCQA feature, select this option. For more information about the MCQA feature, see MaxCompute Query Acceleration.

    Enable the file upload feature

    After you enable this feature, you can upload files.

    Initialize SQL statements

    The SQL statement that is initialized and executed after each data source connection. Only SET statements are allowed. The statements are separated by semicolons and line breaks are not allowed.

  4. Click Test Connection to verify that the data source can be connected.

    image

  5. Click OK.

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

    Note

    After you add a MaxCompute data source, Quick BI asynchronously loads and updates data from MaxCompute. If you add the data source for the first time, wait one to five minutes for data synchronization.

What to do next

After you add a data source, you can create a dataset and analyze data.