EMR StarRocks Manager is a data management console for Serverless StarRocks instances. Use it to manage data, run diagnostics and analysis, and configure security permissions.
Prerequisites
A Serverless StarRocks instance is required. For more information, see Create an instance.
Step 1: Access StarRocks Manager
Access the StarRocks Manager page as follows.
-
Go to the E-MapReduce Serverless StarRocks instance list page.
-
Log on to the E-MapReduce console.
-
In the navigation pane on the left, choose .
-
In the top menu bar, select the required region.
-
-
On the Instances page, find your instance and click StarRocks Manager in the Actions column.
Step 2: Create a connection
A connection enables you to use metadata management, diagnostics, analysis, user management, and authorization features.
-
On the New Connection tab, configure the following parameters.
Parameter
Example
Description
Region
China (Hangzhou)
Select the region where your StarRocks instance resides.
Instance
StarRocks_Serverless
Select the StarRocks instance you want to connect to.
Name
Connection_Serverless
Enter a custom connection name.
The name must be 1 to 64 characters in length and can contain Chinese characters, letters, digits, hyphens (-), and underscores (_).
Username
Enter a value based on your actual needs.
The default username is admin. You can also create other users as needed. For more information, see Manage Users and Data Authorization.
Password
Enter a value based on your requirements.
The password for the specified username.
-
Click Test Connectivity.
-
Once the connection test succeeds, click OK.
Step 3: Add users and configure permissions
Add users to your instance and manage their permissions to control database access. For more information, see Manage users and data authorization.
Step 4: View databases or tables
View databases, tables, partitions, shards, and import tasks in your instance.
-
In the navigation pane on the left, click Metadata Management.
The page displays all catalogs in the current account.
NoteStandard users cannot view the database size or the number of tables.
-
Click a catalog name.
-
Click a database name.
The page displays details about the tables and tasks in the database. For more information, see Manage metadata.
Step 5: Perform diagnostics and analysis
View historical SQL statements, including execution durations and frequencies. The slow query feature helps you analyze long-running statements by providing execution plans and other details to identify performance bottlenecks and optimize queries. For more information, see Query management and analysis.