Add an E-MapReduce Serverless StarRocks data source to connect Quick BI to your StarRocks database. After you add the data source, you can use Quick BI to analyze and visualize your data. You can connect to your StarRocks database over the public network or through an Alibaba Cloud VPC. This topic describes how to add an E-MapReduce Serverless StarRocks data source.
Limitations
Supported versions: 2.5.18, 3.1.7, 3.1.9, and 3.2.6.
Prerequisites
Ensure that you have a stable network connection:
If you connect to the StarRocks database over the public network, add the Quick BI IP addresses to the database whitelist. For more information, see Use a security group.
If you connect to the StarRocks database over an internal network, establish a connection using one of the following methods:
If your StarRocks database is hosted on an Alibaba Cloud Elastic Compute Service (ECS) instance, you can connect to it through an Alibaba Cloud VPC.
You can set up a bastion host and use an SSH tunnel to access the database.
You have created a StarRocks database.
You have obtained the username and password for the StarRocks database.
Procedure
Log on to the Quick BI console.
Follow these steps to add the data source.
For details about how to access the data source creation page, see Create a data source.
On the Alibaba Cloud Databases tab, select the E-MapReduce Serverless StarRocks data source.
In the Configure Connection dialog box, configure the following parameters based on your business requirements.
Parameter
Description
Display name
The display name for the data source. This name is displayed in the list of data sources.
The name cannot contain special characters or have leading or trailing spaces.
Database address
The IP address or domain name of your StarRocks database.
Port
The port number of your database.
Database
The database name you specified when you deployed the StarRocks database.
Username and password
The username and password to log on to the StarRocks database. Ensure that this user has CREATE, INSERT, UPDATE, and DELETE permissions on the database tables.
VPC data source
Select this option and configure the following parameters only if your StarRocks database is deployed on an Alibaba Cloud ECS instance and uses an Alibaba Cloud VPC network.
AccessKey ID: The AccessKey ID of the Alibaba Cloud account that owns the instance.
For more information, see Create an AccessKey.
NoteEnsure that the AccessKey ID has read permission for the target instance. If the AccessKey ID also has the write permission for the corresponding security group, the system automatically adds the Quick BI IP addresses to the whitelist. Otherwise, you must add them manually. For more information, see Create a custom permission policy.
AccessKey Secret: The AccessKey Secret that corresponds to the AccessKey ID.
For more information, see Create an AccessKey.
Instance ID and Region: The StarRocks instance ID and the region where it is located.
You can find the instance ID on the StarRocks instance details page in the E-MapReduce console. For more information, see View instance lists and details.
Initialize SQL
If you enable this option, you can specify SQL statements that automatically run after a connection is established with the data source.
Only
SETstatements are allowed. Separate multiple statements with a semicolon (;).Enable file upload entry
If you enable this option, you can upload files to the data source.
Click Test Connection to test the connection.
After the test succeeds, click OK to add the data source.
Next steps
After you create the data source, you can create a dataset to analyze and visualize your data.
Add tables from the StarRocks database or use custom SQL to create a dataset in Quick BI. For more information, see Create a dataset.
Create a dashboard with visualization charts to analyze your data. For more information, see Create a dashboard and Visualization chart overview.
Drill down for deeper analysis. For more information, see Step 3: Drill-down settings and display.