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
You need to create a MaxCompute project. For more information, see Create a MaxCompute project.
Limits
Versions 1.0 and 2.0 are supported.
Background Information
If you use Alibaba Cloud MaxCompute data warehouse and want to analyze data in Quick BI, you can add a MaxCompute data source. For more information about MaxCompute, see What is MaxCompute.
Limits
Only workspace administrators and developers can add data sources.
Procedure
Log on to the Quick BI console.
Add a data source as shown in the following figure:
Go to the Create Data Source page from the entry for creating a data source.
Select Alibaba MaxCompute data source.
In the Configure Connection dialog box, complete the connection configurations.
Name
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 used to connect to the MaxCompute project. You can use a public network or cloud product interconnection. We recommend that you use the "Cloud Product Interconnection Endpoint" (if the network is not connected, you need to disable the whitelist restriction) to avoid additional costs that may be incurred when accessing through the public network.
Select the corresponding "Cloud Product Interconnection Endpoint" based on the region where your project is located (you can check the region by clicking the upper-left corner after logging in to the MaxCompute console).
For example, the "Cloud Product Interconnection Endpoint" for China (Hangzhou) is https://service.cn-hangzhou-intranet.maxcompute.aliyun-inc.com/api.
Project Name
The name of the MaxCompute project.
Log on to the MaxCompute console, switch to the appropriate region in the upper-left corner, and then you can view the specific MaxCompute project name 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 CreateInstance, List permissions for the project and the Desc permission for tables. If you need to upload files, the account must also have the CreateTable and Write permissions for the project. Log on to the RAM console to 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 Query Acceleration.
Enable File Upload Entry
After this option is enabled, you can upload files.
Init SQL
After this option is enabled, you can configure SQL statements that are executed for initialization after the data source is connected.
The SQL statements that are executed for initialization each time the data source is connected. Only SET statements are allowed. Separate statements with semicolons.
Click Test Connection to test the connectivity of the data source.
After the test is successful, click OK to add the data source.
After the data source is added, you can view the data source in the data source list.
NoteAfter 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.
To add data tables from the MaxCompute data source or custom SQL statements to Quick BI, see Create and manage datasets.
To add visualization charts and analyze data, see Create a dashboard and Overview of visualization charts.
To drill down and perform in-depth data analysis, see Configure and display drill-down analysis.