This topic describes how to go to the details page of a table and view the details of the table, such as the basic information, output information, and lineage information.
Go to the details page of a table
- On the DataStudio page, click
in the upper-left corner and choose . The homepage of Data Map appears.
in the upper-left corner and choose View basic information
In the Basic 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 name, creation time, time-to-live (TTL),
storage capacity, description, and tags of the table, and whether the table is partitioned.
You can perform the following operations in this section:
- View the code of an output node: Click View Code next to the output node. On the Operation Center page that appears, you can view the node code.
- View the details of the MaxCompute project: Click the MaxCompute project name. On the page that appears, you can view the details of the MaxCompute project to which the table belongs.
- Edit the description of the table: Click
next to Description, enter a description in the text box that appears, and then click 
.
- Add a tag to or remove a tag from the table: Click
next to Label, enter a tag name in the text box that appears, and then press the Enter key.
To remove a tag from the table, move the pointer over the tag and click the Remove icon.
next to 
.
next to 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 this section:
- View the details of the workspace: Click the DataWorks workspace name. On the page that appears, you can view the details of the DataWorks workspace to which the table belongs.
- Edit the display name of the table: Click
next to Display Name, enter a name in the text box that appears, and then click .
next to View permission information
In the Permission Information section, you can view your permissions on the table.
In this section, you can click More in the upper-right corner to apply for more permissions on the Table Permission Request page that appears.
View technical information
In the Technical Information section, you can view the technical type, last time when the DDL statement was modified,
last time when the data was modified, last time when the data was viewed, and compute
engine information.
In this section, you can click Click to View next to Compute Engine Information. In the Compute Engine Information dialog box that appears, you can view or copy the information about the compute engine.
Note The default time format used to describe the compute engine is yyyy-MM-dd HH:mm:ss.
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, security level, and popularity of fields. You can also check whether a field is a primary key or foreign key.
Button Description Edit Security Level Click this button. In the Edit Security Level dialog box that appears, specify security levels for fields as needed and click OK. Edit Column Properties Click this button, modify the field description and business description, and then click Save or Cancel as needed. Batch Upload Field Information Click this button and drag the local file to be uploaded to the Batch Upload Field Information dialog box that appears. Download Fields Click this button to download the field information of the current table. Generate DDL Statement Click this button. In the Generate DDL Statement dialog box that appears, view or copy the DDL statement used to create the current table. Generate SELECT Statement Click this button. In the Generate SELECT Statement dialog box that appears, view or copy the SELECTstatement for querying data in 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 performed on the current table.
On this 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, Add Partition, Delete Partition, Change Owner, and Modify Lifecycle.
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 Code or Logs in the Actions column to view the code or logs of a 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 purchase DataWorks Standard Edition or higher. For example,
this feature is available only in DataWorks Standard Edition or higher if the compute
engine is MaxCompute, and available only in DataWorks Professional Edition or higher
if the compute engine is E-MapReduce.
The Lineage tab contains the following tabs: Table Lineage, Field Lineage, and Impact Analysis.
- Table Lineage tab: On this tab, you can search for the ancestor and descendant tables of the current
table based on the globally unique identifier (GUID).
- Field Lineage tab: On this tab, you can select a field from the Field Name drop-down list to view the lineage information of the field.
- Impact Analysis tab: On this 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, project name, and table owner.
You can also download the impact analysis result or send the impact analysis result to the owners of descendant tables of the current table through 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 Currently, the data detection feature is in public preview and is supported only by
the MaxCompute compute engine in the China (Shanghai) region.
DataWorks detects 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 only detect partitioned tables.
- You can only detect tables in the production environment.
- Only the table owner has the permission to enable automatic detection.
On the Data Detection 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. Currently, you can only 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.To configure a manual detection node, follow these steps:
- On the Data Detection tab, click Manual Detection.
- In the Manual Detection dialog box that appears, set parameters as needed.
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. Cost Estimate 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 result on the Data Detection tab.
You can select a detection record from the Detection Records drop-down list to view the data detection result.
- Automatic detection
To configure an automatic detection node, follow these steps:
- Turn on the Auto Detection switch.
- In the Auto Detection (When Partition Information Changes) dialog box that appears, set parameters as needed.
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.
Cost Estimate 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 result on the Data Detection tab.
You can select a detection record from the Detection Records drop-down list to view the data detection result.
View usage notes
On the Instructions 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.
