You can add a StarRocks data source to connect a StarRocks database to Quick BI for analyzing and viewing data in the Quick BI console. Quick BI supports connecting to StarRocks databases through the Internet or Alibaba Cloud VPC. This topic describes how to add an Alibaba Cloud StarRocks data source.
Limits
Versions 2.5.18, 3.1.7, 3.1.9, and 3.2.6 are supported.
Prerequisites
Your network meets the following requirements:
If you connect Quick BI to a StarRocks database over the Internet, add Quick BI IP addresses to the whitelist of the database. For more information, see Add security group rules.
If you connect Quick BI to a StarRocks database over an internal network, use one of the following methods to establish a network connection between the data source and Quick BI:
If the StarRocks database is deployed on an Alibaba Cloud ECS instance, you can connect through Alibaba Cloud VPC.
You can deploy a jump server and access the database over an SSH tunnel.
A StarRocks database is created.
The username and password of the StarRocks database are obtained.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a data source.
Go to the Create Data Source page from the entry for creating a data source.
On the Alibaba Cloud Database tab, select E-MapReduce Serverless StarRocks as the data source.
In the Configure Connection dialog box, configure the following parameters based on your business scenario.
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 address of the StarRocks database, which can be an IP address or a domain name.
Port
The port number of the database.
Database
The name of the database that is created in the StarRocks instance.
Username and Password
The username and password that are used to access the database created in the StarRocks instance. Make sure that the username has the Create, Insert, Update, and Delete permissions on the tables in the database.
VPC Data Source
If the StarRocks database is deployed on an Alibaba Cloud ECS instance and the network type is Alibaba Cloud VPC, select VPC Data Source and configure the following parameters:
Buyer's AccessId: the AccessKey ID of the account that purchases the instance.
For more information, see Obtain an AccessKey pair.
NoteMake sure that the AccessKey ID has the Read permission on the destination instance. If the AccessKey ID has the Write permission on the corresponding security group, the system automatically adds the whitelist. Otherwise, you must manually add the whitelist. For more information, see Create a custom access policy.
Buyer's AccessKey: the AccessKey secret of the account that purchases the instance.
For more information, see Obtain an AccessKey pair.
Instance ID: the ID of the ECS instance. Log on to the ECS Management Console and obtain the instance ID on the Instances tab.
For more information, see View instance information.
Region: the region where the ECS instance is located.
For more information, see View instance information.
NoteCurrently, only the Hong Kong (China) region supports VPC data sources.
Enable File Upload Entry
If this option is enabled, you can upload files.
Click Test Connection to test the connectivity of the data source.
After the test is successful, click OK to add the data source.
What to do next
After you add a data source, you can create a dataset and analyze data.
To add data tables from the StarRocks database 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 into data for in-depth analysis, see Configure and display drill-down analysis.