You can add a StarRocks data source to connect Quick BI to a StarRocks database. Once connected, you can use Quick BI to analyze and visualize the data. Quick BI can connect to a StarRocks database over the public internet or through an Alibaba Cloud VPC. This topic describes how to add an E-MapReduce Serverless StarRocks data source.
Limits
Supported versions: 2.5.18, 3.1.7, 3.1.9, 3.2.6, and 3.5.
Prerequisites
Ensure network connectivity:
If you connect Quick BI to the StarRocks database over the public internet, you must add the Quick BI IP addresses to the database whitelist. For more information, see Use a security group.
If you connect Quick BI to the StarRocks database over an internal network, you can use one of the following methods to establish network connectivity:
If the StarRocks database is deployed on an Alibaba Cloud ECS instance, you can connect through an Alibaba Cloud VPC.
Alternatively, you can set up a jump server and use an SSH tunnel to log on to and access the database.
You have created a StarRocks database.
You have the username and password for the StarRocks database.
Procedure
Log on to the Quick BI console.
Follow these steps to add a data source.
You can go to the create data source interface from Create data source entry point.
On the Alibaba Cloud Databases tab, select E-MapReduce Serverless StarRocks.
In the Configure Connection dialog box, set the parameters as required.
Name
Description
Display name
The display name of the data source in the data source list.
Enter a name that follows the naming conventions. The name cannot contain special characters or leading or trailing spaces.
Database address
The address of the deployed StarRocks database. This can be an IP address or a domain name.
Port
The port number of the database.
Database
The name of the custom database that was created when the StarRocks database was deployed.
Username and password
The username and password used to log on to the StarRocks database. Ensure that the user has the create, insert, update, and delete permissions on the tables in the database.
VPC data source
Select VPC data source and configure the following parameters only if the StarRocks database is deployed on an Alibaba Cloud ECS instance and the network type is Alibaba Cloud VPC:
Purchaser AccessKey ID: The AccessKey ID of the account that purchased the instance.
For more information, see Create an AccessKey.
NoteEnsure that the AccessKey ID has the read permission on the target instance. If the AccessKey ID also has the write permission on the corresponding security group, the system automatically adds the required IP addresses to the whitelist. Otherwise, you must add them manually. For more information, see Create a custom policy.
Purchaser AccessKey Secret: The AccessKey secret of the account that purchased the instance.
For more information, see Create an AccessKey.
Instance ID and Region: The ID and region of the StarRocks database instance.
Log on to the E-MapReduce console and go to the product page of the StarRocks instance to obtain the instance ID. For more information, see View instance list and details.
Init SQL
Enable this option to configure SQL statements that are executed for initialization after a data source connection is established.
Only SET statements are allowed. Use semicolons to separate multiple statements.
Enable file upload entry
Enable this option to allow file uploads.
Click Test Connection to test the connection to the data source.
After the connection is successfully tested, click OK to add the data source.
What to do next
After you create the data source, you can create a dataset and start analyzing data.
To create a dataset from data tables in the StarRocks database or from a custom SQL statement, see Create a dataset.
To add charts for data visualization and analysis, see Create a Dashboard and Overview of charts.
To drill down into your data for in-depth analysis, see Step 3: Configure and view drill-down data.