All Products
Search

This Product

    MaxCompute:Connect Quick BI to MaxCompute

    Document Center

    MaxCompute:Connect Quick BI to MaxCompute

    Last Updated:Aug 28, 2026

    You can connect a MaxCompute project to Quick BI for real-time analysis. Quick BI supports drag-and-drop operations and offers a wide range of visualization options for data analysis, data exploration, and report creation. This topic describes how to connect Quick BI to a MaxCompute project for visual data analysis.

    Background

    Quick BI is an easy-to-use and high-performance big data analytics platform designed for cloud users. It empowers business users to visualize data and drives data-centric operations.

    Prerequisites

    Before you begin, ensure that you meet the following prerequisites:

    • You have a MaxCompute project. For more information, see Create a MaxCompute project.

    • You have the AccessKey ID and AccessKey Secret to access the MaxCompute project. You can obtain them from the AccessKey Pair page.

    • The Quick BI service is activated. This example uses Quick BI Standard Edition (Personal Edition).

    Step 1: Connect Quick BI to MaxCompute

    1. Log on to the Quick BI console.

    2. Follow the steps below to add a data source.

      1. Navigate to the data source creation page from the create data source entry point.

      2. Select the Alibaba MaxCompute data source.image

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

      Parameter

      Description

      Name

      The display name of the data source in the configuration list.

      Enter a valid name. The name cannot contain special characters or leading or trailing spaces.

      Database Address

      The endpoint of the MaxCompute project. Quick BI connects to the MaxCompute service by using the Alibaba Cloud private network endpoint.

      Project Name

      The name of the target MaxCompute project.

      This is the name of the MaxCompute project, not the DataWorks workspace. Log in to the MaxCompute console and select a region in the upper-left corner. In the left-side navigation pane, choose Manage Configurations > Projects, and you can view the specific MaxCompute project name.

      AccessKey ID and AccessKey Secret

      The AccessKey ID and AccessKey Secret that have permissions to access the target MaxCompute project.

      Ensure that the account has the CreateInstance and List permissions on the project, and the Describe permission on tables. If you need to upload files, the account must also have the CreateTable and Write permissions on the project. You can obtain the credentials from the AccessKey Pair page.

      Quota Resource Group

      • If you use the MaxQA feature, enter the MaxQA quota name.

      • If other Quota Resource Groups are available for the MaxCompute project, specify one as needed.

      • If you leave this parameter empty, query acceleration defaults to the MaxCompute MCQA 1.0 feature.

      This parameter is optional.

      Enable File Upload

      If enabled, you can upload files. This option is enabled by default.

      Initialize SQL

      If enabled, you can provide SQL statements to run each time a connection is initialized.

      Only SET statements are allowed, and they must be separated by semicolons (;).

    4. Click Test Connection to test the connection.

      image

      Note

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

    5. After the connection test succeeds, click OK to add the data source.

      Note

      Quick BI adds and updates MaxCompute cloud data sources asynchronously. The initial data synchronization may take 1 to 5 minutes.

      The new data source will then appear in the data source list.

    Step 2: Query and analyze data

    In the Quick BI console, you can query and analyze data from your MaxCompute project using the new data source.