View the details of a table - Data governance| Alibaba Cloud Documentation Center

Go to the details page of a table

Log on to the DataWorks console.
In the left-side navigation pane, click Workspaces.
On the Workspaces page, find the workspace in which you want to view the details of a table and click Data Analytics in the Actions column.
On the DataStudio page, click the icon in the upper-left corner and choose All Products > Data governance > DataMap. The homepage of Data Map appears.
In the top navigation bar, click All Data.
On the All Data page, click a tab as required, such as MaxCompute.
On the tab that appears, click the name of the table that you want to view.
On the details page that appears, you can view the basic information, business information, permission information, technical information, detailed information, output information, lineage information, reference records, and usage notes of the table. You can also preview and detect data in the table.

View basic information

In the Basic table information section, you can view the numbers of reads, favorites, and views. You can also check the output nodes, MaxCompute project name, region to which the current workspace belongs, region to which the engine belongs, owner, creation time, time-to-live (TTL), storage capacity, description, and tags of the table, and whether the table is partitioned. Basic table information section

You can perform the following operations in the Basic table information section:

View the code of the output node of the table: Click View Code next to Output Node. On the Operation Center page, view the node code.
If the table has multiple output nodes, move the pointer over View tasks next to Output Node. In the pop-up window, find the output node whose code you want to view and click View Code in the Details column.
View the details about the MaxCompute project: Click the MaxCompute project name. On the page that appears, view the details about the MaxCompute project to which the table belongs.
Edit the description of the table: Click the icon next to Description, enter a description in the field that appears, and then click the icon.
Add a tag to or remove a tag from the table: Click next to Tags, enter a tag name in the field that appears, and then press the Enter key.
To remove a tag from the table, move the pointer over the tag and click the X icon.

View business information

In the Business Information section, you can view the DataWorks workspace name, environment type, category, and display name of the table.

You can perform the following operations in the Business Information section:

View the details about the workspace: Click the DataWorks workspace name. On the page that appears, view the details about the DataWorks workspace to which the table belongs.
Edit the display name of the table: Click the icon next to Display Name, enter a name in the field that appears, and then click the icon.

View permission information

In the Permission Information section, you can view your permissions on the table.

In the Permission Information section, you can click More in the upper-right corner. In the Apply for Permission dialog box, you can request more permissions on the table.

View technical information

In the Technical Information section, you can view the technical type, last time when the data definition language (DDL) statement was modified, last time when the data was modified, last time when the data was viewed, and compute engine information.

In the Technical Information section, you can click View next to Compute Engine Information. In the Compute Engine Information dialog box, you can view or copy the information about the compute engine.

Note By default, the time format yyyy-MM-dd HH:mm:ss is used to describe the compute engine.

View detailed information

The Details tab contains the following tabs: Field Information, Partitions, and Change Records.

Field Information tab

On the Field Information tab, you can view the name, data type, description, business description, and popularity of each field. You can also check whether a field is a primary key or foreign key.

If the table is a partitioned table, you can also view the information about partition fields, including the field name, data type, description, and business description. Field Information tab


Action	Description
Edit	Click this button. You can modify the field description and business description, specify the security level, and specify whether a field is a primary key. Then, click Save or Cancel as needed. You can specify a security level for multiple fields at a time. Note You can specify security levels for fields only in a MaxCompute project with LabelSecurity enabled.
Upload	Click this button. In the Batch Upload Field Information dialog box, drag and upload a local file. Only .xlsx files created in Excel 2007 are supported. You can also click Download Template.
Download	Click this button to download the field information of the current table.
Generate select	Click this button. In the Generate SELECT Statement dialog box, view or copy the `SELECT` statement that you can use to query data in the current table.
Generate DDL.	Click this button. In the Generate DDL Statement dialog box, view or copy the DDL statement that is used to create the current table.

Partitions tab
On the Partitions tab, you can view the name, number of records, storage capacity, creation time, and last update time of each partition in the current table.
Change Records tab
On the Change Records tab, you can view the description, type, granularity, time, and operator of changes that are performed on the current table.

On the Change Records tab, you can also select a change type from the drop-down list in the upper-left corner to filter the table changes.

Change types include Create Table, Modify Table, Delete Table, Create Partition, Delete Partition, Change Owner, and Change TTL.

View output information

If the table data periodically changes with the corresponding node, you can view the change status and data that is continuously updated on the Instances tab.

On this tab, you can also click View Code or View Log in the Actions column of a node to view the code or logs of the node.

View lineage information

On the Lineage tab, you can view the source and destination of data and manage the lineage information with ease.

Note To use this feature, you must activate a DataWorks advanced edition. For example, if the compute engine is MaxCompute, this feature is available only in DataWorks Standard Edition or more advanced editions. If the compute engine is E-MapReduce, this feature is available only in DataWorks Professional Edition or more advanced editions.

The Lineage tab contains the following tabs: Table Lineage, Field Lineage, and Impact Analysis.

The Table Lineage tab consists of the Graph Analysis and Hierarchical view tabs.
- Graph Analysis tab: displays the ancestor and descendant tables of a specified level for the current table and the number of ancestor and descendant tables for each table.
- Hierarchical view tab: displays the parent and child tables of the current table by default. You can search for the parent and child tables based on the globally unique identifier (GUID).
On the Field Lineage tab, you can select a field from the Field Name drop-down list to view the lineage information of the field.
On the Impact Analysis tab, you can query the node that generates a lineage and the full link of the lineage based on information such as the lineage level, field, node type, table name, workspace name, and table owner.
You can click Manual update to rerun the impact analysis. You can also download the impact analysis result or send the impact analysis result to the owners of descendant tables of the current table by sending emails.

View reference records

The Records tab contains the following tabs: Foreign Key References and Access Statistics.

Foreign Key References tab: On this tab, you can check the number of users who reference the current table.
Access Statistics tab: On this tab, you can view the reference records in a line chart.

Preview data

On the Data Preview tab, you can preview the data of the current table.

Notice Only authorized users can preview tables in the production environment. If you do not have the required permissions, click Apply Now.

Detect data

Notice The data detection feature is in public preview and is supported only by the MaxCompute compute engine in the China (Shanghai) region.

DataWorks detects the data of a table based on the schema and a partition key value. The data detection results include basic statistics and data distribution.

The data detection feature has the following limits:

You can detect only partitioned tables.
You can detect only tables in the production environment.
Only the table owner has the permission to enable automatic detection.

On the Data Profiling tab, you can set the detection mode and view detection records.

You can detect a table in a manual or an automatic manner:

Manual detection

Note Data detection nodes are run in the MaxCompute project to which a detected table belongs. You can detect a maximum of 10 columns in a single table at a time. To save resources, select only the columns that need to be detected when you configure a manual detection node.

If you want to configure a manual detection node, perform the following steps:

On the Data Profiling tab, click Manual Profiling.

In the Manual Profiling dialog box, set the parameters as required.


Parameter	Description
Table Name	The name of the table, in the format of Workspace name.Table name. The value of this parameter is generated by the system and cannot be modified.
Partition Value	The key value of the partition to be detected. Select a partition from the drop-down list.
Detailed Configuration	The columns to be detected. Select columns as needed.
Estimated Cost	The estimated cost of the detection node. The cost is estimated based on the preceding settings. Notice MaxCompute SQL statements may be executed to detect data. In this case, you will be charged for using the MaxCompute service. Note that the estimated cost is for reference only. The actual cost may vary with the volume of the detected data. Check your MaxCompute bill for the actual cost.

Select I understand that using this service will be charged.
Click Commit.
After the detection node is run, view the data detection results on the Data Profiling tab.
You can select a detection record from the Profiling Records drop-down list to view the data detection results.

Automatic detection

If you want to configure an automatic detection node, perform the following steps:

Turn on Auto Profiling.

In the Auto Profiling (When Partition Information Changes) dialog box, set the parameters as required. Auto Profiling switch


Parameter	Description
Table Name	The name of the table, in the format of Workspace name.Table name. The value of this parameter is generated by the system and cannot be modified.
Partition Value	The latest partition key value when data detection is triggered. The value of this parameter is generated by the system and cannot be modified.
Detailed Configuration	The columns to be detected. Select columns as needed.
Bind Trigger	The scheduling node that triggers the detection node. Select a scheduling node from the drop-down list. You can view the IDs of scheduling nodes in Operation Center. We recommend that you select the output node of the current table. If you bind a scheduling node to an automatic detection node and commit the detection node, the system detects the latest partition after the scheduling node is run.
Estimated Cost	The estimated cost of the detection node. The cost is estimated based on the preceding settings. Notice MaxCompute SQL statements may be executed to detect data. In this case, you will be charged for using the MaxCompute service. Note that the estimated cost is for reference only. The actual cost may vary with the volume of the detected data. Check your MaxCompute bill for the actual cost.

Select I understand that using this service will be charged.
Click Commit.
After the detection node is run, view the data detection results on the Data Profiling tab.
You can select a detection record from the Profiling Records drop-down list to view the data detection results.

View usage notes

On the Usage Notes tab, you can edit usage notes, check the historical versions of the usage notes, and view the Markdown syntax. You can also learn the relevant information based on the description of the data.