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
-
Log on to the Quick BI console.
-
Add a MaxCompute data source.
-
Navigate to the data source creation page from the create data source entry point.
-
Select the Alibaba MaxCompute data source.
-
In the Configure Connection dialog box, configure the following parameters.
Parameter
Description
Name
A name for the new data source, such as MaxCompute.
Database Address
The endpoint for the MaxCompute project. Quick BI connects to the MaxCompute service through 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 workspace. You can log on to the MaxCompute console, switch the region in the upper-left corner, and then find the project name on the Workspace > Projects page.
AccessKey ID
The AccessKey ID that has permissions to access the target MaxCompute project. You can obtain it from the AccessKey Pair page.
AccessKey Secret
The AccessKey Secret that corresponds to the AccessKey ID.
Quota Resource Group
-
If you use the MaxQA feature of MaxCompute, enter the MaxQA quota name.
-
If other Quota Resource Groups are available for the MaxCompute project, specify one as needed.
-
If you leave this blank, the MaxCompute MCQA 1.0 feature is used for query acceleration by default.
This parameter is optional.
Enable File Upload
If enabled, you can upload files. This option is enabled by default.
-
-
Click Test Connection to test the connection.
For information about data source permission issues, see Solutions and common errors when connecting to a MaxCompute data source in Quick BI.
-
After the connection test succeeds, click OK to add the data source.
NoteQuick 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.
-
Add tables or custom SQL queries from your MaxCompute data source. Create a dataset.
-
To add visual charts and analyze data, see Create a dashboard and Visual chart overview.
-
Drill down into data for in-depth analysis. Step 3: Configure and display drill-down data.