Data Management is a visualization tool in ApsaraDB for SelectDB. For any table, you can view its database and table schemas, data size, CREATE TABLE statement, column definitions, indexes, and a data preview.
Prerequisites
Before you begin, make sure you have:
-
An ApsaraDB for SelectDB instance running version 3.0.7 or later. To create one, see Create an instance
Open Data Management
-
Log on to the ApsaraDB for SelectDB console.
-
In the top navigation bar, select the region where your instance resides.
-
In the left-side navigation pane, click Instances. On the Instances page, find your instance and click its ID to go to the Instance Details page.
-
In the upper-right corner, click Data Development and Management and select Data Management from the drop-down list.
The first time you open Data Development and Management, a prompt asks you to add your machine's public IP address to the IP address whitelist named webui_whitelist. Click OK to proceed.
-
If this is your first time accessing Data Management and you have not logged on to the WebUI system, the WebUI logon page appears. Log on using the admin account. If you have forgotten the admin password, see Reset the password of an account.
-
On the Data page, enter a table name in the search box at the top of the left panel and select the table from the results. The four tabs appear on the right side of the page: Table Details, Columns, Indexes, and Data Overview.
What's next
-
Create an instance — set up a new ApsaraDB for SelectDB instance
-
Data table design — learn how tables are structured in SelectDB
-
Configure an IP address whitelist — manage access to your instance
-
SQL reference — run queries against your data