All Products
Search
Document Center

MaxCompute:Connect Quick BI to MaxCompute

Last Updated:Nov 13, 2024

You can connect Quick BI to a MaxCompute project to analyze large amounts of data in the MaxCompute project in real time. You can perform drag-and-drop operations and use various visualization methods to analyze MaxCompute data, explore business data, and generate reports in the Quick BI console. This topic describes how to connect Quick BI to a MaxCompute project and analyze MaxCompute data in the Quick BI console in a visualized manner.

Background information

Quick BI is an easy-to-use, high-performance big data analytics and visualization platform that is developed for users in the cloud. Quick BI is a user-friendly platform that allows all users to perform the tasks of a data analyst. Quick BI not only allows business personnel to visualize data, but also helps in the development of digital operations. For more information about Quick BI, see Quick BI.

Prerequisites

Make sure that the following conditions are met:

  • A MaxCompute project is created.

    For more information about how to create a MaxCompute project, see Create a MaxCompute project.

  • The AccessKey ID and AccessKey secret that are used to access the MaxCompute project are obtained.

    You can obtain the AccessKey ID and AccessKey secret on the AccessKey Pair page.

  • The Quick BI service is activated.

    In this topic, Quick BI Basic is used.

Step 1: Connect Quick BI to MaxCompute

  1. Log on to the Quick BI console.

  2. In the top navigation bar, click Workspace. In the left-side navigation pane, click Data Sources.

    Data Sources

  3. In the upper-right corner, click Create Data Source. On the Cloud Data Sources tab of the Add Data Source dialog box, click the MaxCompute card. In the Add MaxCompute Database dialog box, configure the parameters as described in the following table.

    Create Data Source

    Parameter

    Description

    Name

    The name of the data source. For example, you can set this parameter to MaxCompute.

    Database Address

    The endpoint of MaxCompute. Quick BI can use the endpoint of the cloud product interconnection network to connect to the MaxCompute project. For more information, see Endpoints.

    Project Name

    The name of the MaxCompute project.

    This parameter specifies the name of your MaxCompute project instead of the DataWorks workspace to which the MaxCompute project corresponds. To view the name of a MaxCompute project, perform the following steps: Log on to the MaxCompute console. In the top navigation bar, select a region. View the name of the MaxCompute project on the Workspace > Project management tab.

    AccessKey ID

    The AccessKey ID that is used to access the MaxCompute project.

    You can obtain the AccessKey ID from the AccessKey Pair page.

    AccessKey Secret

    The AccessKey secret that corresponds to the AccessKey ID.

    You can obtain the AccessKey secret from the AccessKey Pair page.

    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.

  4. In the Add MaxCompute Database dialog box, click Test Connection. If the connectivity test is successful, click OK to connect Quick BI to the MaxCompute project.

Step 2: Use Quick BI to query and analyze data

In the Quick BI console, you can query and analyze data in the MaxCompute project based on the added MaxCompute data source. You can perform the following operations. For more information, see Manage tables in a data source and Data analysis.

  • View all tables in the MaxCompute project

    After you add the MaxCompute data source, you are automatically redirected to the Data Sources page. Information about all tables in the MaxCompute project is automatically displayed on the Tables tab.

    All tables

  • View the schema of a table

    After you add the MaxCompute data source, find the table whose schema you want to view on the Tables tab and click the Details icon in the Actions column.

    View the schema of a table

  • View data in a table

    After you add the MaxCompute data source, find the table whose data you want to view on the Tables tab and click the Create Dataset icon in the Actions column. In the dialog box that appears, write SQL code. Then, view and save the data.

    View data in a table

  • Visualize data

    After you write SQL code to create a data table, you can create a dashboard and configure properties to visualize data in the table based on your business requirements. The operations that are used to create a data table are similar to the operations that are used to view data in a table.