Data Management (DMS) allows you to view the technical metadata, business metadata, and management metadata of a table on the Tables page. Technical metadata includes the database and instance where the table resides, table name, and fields. Business metadata includes the business description and tags of the table. Management metadata includes the owner of the table and your permissions on the table. DMS also allows you to manage the table by performing simple operations on this page. The Tables page can help you fully understand and efficiently use the data of the table.
Data governance helps you manage all data assets. Data governance is the key to the digital transformation of enterprises. In view of this, DMS provides the metadata of a table on the Tables page, such as technical metadata, business metadata, and management metadata. This helps developers and business staff understand the relationships between upstream and downstream data and the purpose of the data in the table. This also improves the development and management efficiency.
- Technical metadata: the physical information about the table in the database, such as the database and instance where the table resides, table name, comments, fields, indexes, character set, number of rows, capacity, data lineage, task information, and data quality.
- Business metadata: the business information that is used to describe and manage the table, such as the tags, category, and description of the table, the description of a field, and usage notes.
- Management metadata: the information that is used to manage the table in DMS, such as the permissions, control fields, and owner of the table.
- A relational database or data warehouse is used. For more information, see Supported database types.
- You have one of the following permissions:
- You are a DMS administrator or a database administrator (DBA) in DMS. Alternatively, you have the read-only permissions on the schema of a table. For more information, see System roles.
- You are the owner or the DBA of the database instance that you want to manage. For more information, see Modify an instance.
- You have the permissions to query, change, or export the data of a database or a table in the database. For more information, see View owned permissions.
- Log on to the DMS console.
- In the search box at the top of the DMS console, enter the name of the table that you want to query. Click Details to go to the Tables page.
Note To go to the Tables page, you can also click the Table List icon ( ) in the SQLConsole, and click the name of the table that you want to query.
- On the Tables page, perform relevant operations as required.
Table 1. GUI of the Tables page Section Description Table overview You can view the following parameters:
Note If you are the owner of the table, a DMS administrator, or a DBA, you can modify the parameters, such as Data Owner, Tag, Business Description, and Category.
- Character Set, DB Information, Rows, Capacity (MB), and Description. The Description parameter indicates the comments on the table.
- Environment: the environment type of the database instance to which the table belongs, such as the development or test environment. For more information, see Change the environment type of an instance.
- Permission: the permissions that you have on the table.
- Data Owner: the owner of the table.
- Tag: the one or more tags of the table. You can add phrases as tags for classification.
- Business Description: the business description of the table. The description can be up to 1,000 characters in length. This can help relevant users understand the purpose of the table.
- Category: the category of the table. You can select a category for the table in a category tree. For more information, see Use the category feature.
Basic information On the Basic Info tab, you can view Field Information, Index and Row-level control fields of the table.
- Field Information: displays the basic information about each field in the table, such as Field Name, data type, description, Security Level, Security Level Source, Business Description.
Note If you are the owner of the table, a DMS administrator, or a DBA, you can modify the business description of each field. To modify the business description of a field, find the field and double-click the description in the Business Description column.You can also perform the following operations:
- Generate a SELECT Statement: View the SELECT statement that is used to query all fields in the table.
- Export Schema: View the schema of the table in the format of a data dictionary. You can export the schema to a Word, Excel, or PDF file.
- Generate a DDL Statement: View the complete DDL statement that is used to create the table.
- Adjust Security Level: Change the security level of each field. For more information, see Adjust field security levels.
- Code Generator: Generate code in various formats.
- Index: displays Index Name, Index Type, Included Columns, remarks for each index.
- Row-level control: displays the information about Control field. To view Control value details, click Details in the Actions column.
When you use the task orchestration feature to synchronize and process the data of the table, the data flows.
The Data Lineage tab displays how data flows from tables to tables or from fields to fields. This tab helps you fully understand upstream and downstream data. This can help you resolve issues about data governance, such as repeated data processing and unauthorized use of data. In addition, data lineage also helps you minimize the impact that is caused by data changes.The following sample SQL statements can generate table lineage or field lineage:
- Table lineage:
INSERT INTO table1 SELECT * FROM table2;
- Field lineage:
INSERT INTO table1 (col1, col2) SELECT col3 , col4 FROM table2;
To view the upstream and downstream of a table or a field, click the icon on the left and right sides of the table or field. The upstream data is displayed on the left side and the downstream data is displayed on the right side.
Historical Versions On the Historical Versions tab, you can view the schema versions of the table. You can also perform the following operations:
- Preview script: Preview the SQL script that is used to generate the schema version.
- Table structure comparison: Synchronize the schema version to another database, or compare the schema version with a schema version in another database. For more information, see Synchronize schemas.
- Structural recovery: Synchronize the schema version that you want to restore to an empty database. For more information, see Initialize empty databases.
Task Information If you use the task orchestration feature to write data to the table, you can view the information about each task, such as the task name, start time, duration, and end time.Execution TimeYou can also perform the following operations:
- Click Code to view the code of the task on the task orchestration page.
- Click Log to view the operational logs of the task.
Data Preview On the Data Preview tab, you can view the first 50 data entries in the table.Note You must have the permissions to query the data of the table or the database to which the table belongs. For more information, see View owned permissions. Data quality On the Data quality tab, you can create quality rules for the table. Then, you can use the quality rules on the task orchestration page to check whether the data of the table is valid. This improves data quality. For more information, see Data quality. Instructions for Use On the Instructions for Use tab, you can edit the usage notes and additional information of the table that help other users understand and use the table. The Markdown syntax is supported.Note All users can view the usage notes. To edit the usage notes, you must be a DMS administrator, a DBA, or the owner of the table.