In Data Management (DMS), common users access databases through a permission request workflow. Request access, query or modify data in the SQL console, and submit tickets for bulk data operations.
Request access and get started
-
Log in to the DMS console and submit a ticket to request permissions on the instance, database, and table you need. For details, see Permission management.
-
After your ticket is approved, open SQLConsole for the target database. Write an SQL statement in the code editor and click Execute. The results appear as a table below the editor, and you can edit the returned data directly. For details, see SQL console and Cross-database query.
-
To change, import, or export data in bulk, submit a ticket for the corresponding operation:
-
Data changes — data modification workflows
-
Import data — bulk imports
-
Data export — large-scale data extraction
-
Available features
|
Category |
Feature |
Description |
|
Permissions |
Request permissions on resources such as instances, databases, tables, and sensitive columns. You can also view your existing permissions. |
|
|
SQLConsole |
Use the SQL window to write and execute SQL statements for single-database queries. This feature is useful for scenarios such as verifying data for online business code, analyzing product performance data, and troubleshooting online issues. |
|
|
Perform join queries on online disparate data sources across different environments. |
||
|
Table Schemas |
Use the schema design feature of DMS to create or modify tables for new projects, new requirements, or optimization tasks. |
|
|
Compare table schemas between different environments, such as staging and production environments, to ensure schema consistency. |
||
|
Optimization |
The SQL review feature helps you avoid SQL statements that have no indexes or do not follow standards. This reduces the risk of SQL injection. |
|
|
Data Plans |
Change data to meet requirements such as data initialization for new releases, historical data cleanup, issue fixing, and testing. |
|
|
Use the data import feature to import data into a database in batches. |
||
|
Use the data export feature for large-scale data analytics or data extraction. |
||
|
If data becomes inconsistent due to misoperations, use data tracking to quickly restore the data to a normal state. |
||
|
Test data structures ensure data security and discreteness and improve production efficiency during frequent Data Preparation. |
||
|
Data Warehouse Development uses databases as the primary computing engine. It integrates various tools and services from the database ecosystem, such as DTS and Data Lake Analytics (DLA), to help you easily develop and manage a data warehouse. |
||
|
DataService Studio provides features such as fine-grained data output, visualization creation, and sales on Alibaba Cloud Marketplace. |
||
|
The database cloning feature lets you clone MySQL databases. |
||
|
Tickets |
DMS provides in-product ticket approval and sends notifications about ticket execution status via DingTalk and email. |