Connect your StarRocks database to Quick BI by adding an E-MapReduce Serverless StarRocks data source. After the connection is established, you can analyze and visualize data in Quick BI. Both public network and Alibaba Cloud VPC connections are supported.
Limitations
Versions 2.5.18, 3.1.7, 3.1.9, and 3.2.6 are supported.
Prerequisites
Your network connection is properly configured:
If you are connecting Quick BI to your StarRocks database over the public network, add the Quick BI IP addresses to the database's whitelist. For more information, see Security groups.
If you are connecting Quick BI to your StarRocks database over an internal network, establish a connection between the data source and Quick BI by using one of the following methods:
If your StarRocks database is hosted on an Alibaba Cloud ECS instance, you can connect through a VPC.
Alternatively, you can set up a bastion host and use an SSH tunnel to access the database.
A StarRocks database is created.
You have the username and password for the StarRocks database.
Procedure
Log on to the Quick BI console.
Follow these steps to add the data source.
Navigate to the page to create a data source.
On the Alibaba Cloud Databases tab, select E-MapReduce Serverless StarRocks.
In the Configure Connection dialog box, set the following parameters.
Parameter
Description
Display name
The display name for the data source in the data source list.
The name must not contain special characters or leading or trailing spaces.
Database address
The endpoint 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 you specified when deploying StarRocks.
Username and password
The username and password for logging on to the StarRocks database. The user must have CREATE, INSERT, UPDATE, and DELETE permissions on the tables in the database.
VPC data source
If your StarRocks database is deployed in a VPC on an Alibaba Cloud ECS instance, enable this option and configure the following parameters:
AccessKey ID: The AccessKey ID of the account that owns the instance.
For more information, see Create an AccessKey.
NoteEnsure that this AccessKey ID has read permissions on the target instance. If the key also has write permissions for the relevant security group, the system automatically adds the required Quick BI IP addresses to the security group. Otherwise, you must add them manually. For more information, see Create a custom policy.
AccessKey Secret: The AccessKey Secret of the account that owns the instance.
For more information, see Create an AccessKey.
Instance ID and region: The ID of the StarRocks database instance and the region where it is deployed.
To obtain the instance ID, log on to the E-MapReduce console and go to the details page of the StarRocks instance. For more information, see View instance list and details.
NoteThe VPC data source option is available only in the China (Hong Kong) region.
Initialization SQL
Enable this option to specify SQL statements that initialize each new connection to the data source.
Only SET statements are allowed. Separate multiple statements with a semicolon (;).
Enable file upload
Enable this option to allow file uploads.
Click Test Connection to verify the connection.
If the connection test is successful, click OK to add the data source.
Next Steps
After the data source is created, you can create a dataset and start analyzing your data.
Add tables or custom SQL queries from your StarRocks database to Quick BI to create a dataset. For more information, see Create and manage a dataset.
Create a dashboard and add visual charts to analyze your data. For more information, see Create a dashboard and Overview of visual charts.
Perform drill-down analysis for in-depth insights. For more information, see Step 3: Configure and display drill-down analysis.