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
- Go to the details page of a table from the Workspaces page
- Log on to the DataWorks console.
- In the left-side navigation pane, click Workspaces.
- In the top navigation bar, select the region where your workspace resides. On the Workspaces page, find the desired workspace and click Data Map in the Actions column. The homepage of DataMap appears.
- On the Table tab, select a data source type from the drop-down list and enter a keyword in the search box to search for the table whose details you want to view. In this topic, MaxCompute is selected. Find the table in the results that are displayed and click the table name to go to the details page of the table.
- Go to the details page of a table from the All Data tab
- Log on to the DataWorks console.
- In the left-side navigation pane, click Workspaces.
- In the top navigation bar, select the region where your workspace resides. On the Workspaces page, find the desired workspace and click Data Map in the Actions column. The homepage of DataMap appears.
- In the top navigation bar of the DataMap page, click All Data.
- On the Table tab, select a data source type from the drop-down list and enter a keyword in the search box to search for the table whose details you want to view. In this topic, MaxCompute is selected. Find the table in the results that are displayed and click the table name to go to the details page of the table.
View the details of a table

Area | Description |
---|---|
1 | In this area, you can perform the following operations on a table:
|
2 | In this area, you can search for a table by keyword that is contained in a table name, field name, or project name. |
3 | In this area, you can view the information of a table in the following sections:
|
4 | In this area, you can view the information of a table on the following tabs:
|
View information on the Details tab
- Field Information: On this subtab, you can view the field information of a table. If the table is a
partitioned table, you can also view partition fields in the table that are displayed
in the Partition Fields section.
Operation Description Edit You can click this button to modify Description, Business Description, Security Level, and Primary Key. You can also save the modified information or cancel the modification. You can specify a security level for multiple fields at a time.Note- Only a workspace member that is assigned the Workspace Manager role or the table owner can modify settings for table fields. If you want to modify settings for table fields, you must obtain the permissions of the Workspace Manager role. For more information, see Manage global roles and members.
- The Security Level column is displayed on the Field Information subtab only for MaxCompute tables for which you specify field security levels.
- The security level feature is exclusive to MaxCompute.
- You can specify security levels for fields in a MaxCompute table on the Field Information subtab only after you enable the security level feature in the MaxCompute compute engine instance associated with the current workspace. For more information about how to enable the security level feature, see Label-based access control.
Batch Edit Security Level You can click this button to specify or modify security levels for multiple table fields at a time. This improves data security. Note- The security level feature is exclusive to MaxCompute.
Upload You can click this button and drag the file that you want to upload from your on-premises machine to the Batch Upload Field Information dialog box. Note- Only a workspace member that is assigned the Workspace Manager role or the table owner can upload data to a table whose details are displayed on this page. If you want to upload data to a table whose details are displayed on this page, you must obtain the permissions of the Workspace Manager role. For more information, see Manage global roles and members.
- Only .xlsx files created in Excel 2007 are supported. You can also click Download Template File to download the template file.
Download You can click this button to download the field information of the table. Generate SELECT Statement You can click this button to view or copy the SELECT
statement in the Generate SELECT Statement dialog box. The statement can be used to query the table data.Generate DDL Statement. You can click this button to view or copy the data definition language (DDL) statement in the Generate DDL Statement dialog box. The statement can be used to create the table. Note The Number of Reads parameter represents the number of times that a field is specified in JOIN statements on the previous day. The value of this parameter is presented in the form of star rating based on the proportion of the number of times the field is specified in JOIN statements to the total number of times all fields in the table are specified in JOIN statements. The highest level of star rating is 5, and the lowest level of star rating is 0. - Partition Information: On this subtab, you can view information such as Partition Name, Records, and Storage. This subtab displays only the information of partitioned MaxCompute tables. Note The data in the Records and Storage columns are for reference only. The data displayed on the Partition Information subtab may not be updated in real time. The data in the compute engine instance prevails.
- Change Records: On this subtab, you can view information such as Description, Change Type, and Object.
You can select a change type from the Change Type drop-down list on the Change Records subtab to view the related table changes.
Change types include Create Table, Modify Table, Drop Table, Create Partition, Drop Partition, Modify Owner, and Modify TTL.
View lineage information on the Lineage tab
- The lineage feature is supported only in DataWorks Standard Edition or a more advanced edition. For example, if the compute engine is MaxCompute or E-MapReduce (EMR), this feature is available in DataWorks Standard Edition or a more advanced edition.
- The lineage information displayed on this tab for a MaxCompute table includes the lineages between tables and the lineages between fields. The lineages are obtained by parsing the data of ODPS SQL scheduling jobs. The lineages that are generated by manual operations, such as ad hoc queries, are not included. The lineage information displayed on the Lineage tab is collected in offline mode and is updated one day later.
- The Table Lineage tab consists of the Graph Analysis and View by Level subtabs.
- Graph Analysis: On this subtab, you can view the number of ancestor and descendant tables at all
levels of the table. You can also view the total number of ancestor and descendant
tables for each table.
- View by Level: On this subtab, you can view the ancestor and descendant tables at the nearest level
of the table by default. You can search for ancestor and descendant tables based on
their globally unique identifiers (GUIDs).
- Graph Analysis: On this subtab, you can view the number of ancestor and descendant tables at all
levels of the table. You can also view the total number of ancestor and descendant
tables for each table.
- Field Lineage: On this tab, you can select a field in the table from the Field Name drop-down list to view the lineage information of the field.
- Impact Analysis: On this tab, you can specify one or more of the following conditions to view Scheduling Output or Full Link of the lineage: Lineage Level, Node Type, Table Name, Project Name, and Table Owner.
You can click Start Analysis to perform an impact analysis. After the analysis is complete, you can download the impact analysis result. You can also enable the system to send the impact analysis result to the owners of descendant tables of the current table by email.
Detect data on the Data Profiling tab
DataWorks detects the data of a table based on the schema and a partition key value. The data profiling results include basic statistical information and data distribution.
- Only data in partitioned tables can be detected.
- Only tables in the production environment can be detected.
- Only the table owner can enable the Auto Profiling feature.

- Manual ProfilingNote Data profiling tasks run in the MaxCompute project to which a detected table belongs. The system can detect a maximum of 10 columns in a table at a time. To save resources, select only the columns that you want to detect.To perform manual profiling, perform the following steps:
- On the Data Profiling tab, click Manual Profiling.
- In the Manual Profiling dialog box, configure the parameters.
Parameter Description Table Name The name of the table that you want to detect. By default, the table name is presented in the Workspace name.Table name format and cannot be changed. Partition Value The partition that you want to detect. You can select the desired partition from the Partition Value drop-down list. Detailed Configuration The columns that you want to detect. You can select the desired columns. Estimated Cost The estimated cost for running the data profiling task. The cost is estimated based on the settings of the preceding parameters. Notice- To detect data in the MaxCompute table, you must execute MaxCompute SQL statements. In this case, you will be charged for using the MaxCompute service. The estimated cost is for reference only. The actual cost may vary based on the amount of data that is detected. You can check the bills for MaxCompute to view the actual cost.
- Features provided by Data Quality are used during data profiling. When you run a data profiling task, fees are generated in Data Quality and charged by DataWorks. For more information, see Overview.
- Select I understand that using this service will be charged.
- Click Commit.
- After the data profiling task is complete, view the data profiling results on the
Data Profiling tab.
You can select an option from the Profiling Records drop-down list to view the desired data profiling result. You can choose to view the distribution of data values in a field.
- Auto ProfilingTo enable auto profiling, perform the following steps:
- Turn on Auto Profiling.
- In the Auto Profiling (When Partition Information Changes) dialog box, configure the parameters.
Parameter Description Table Name The name of the table that you want to detect. By default, the table name is presented in the Workspace name.Table name format and cannot be changed. Partition Value By default, the partition value is the latest partition value when data profiling is triggered. You cannot change the value. Detailed Configuration The columns that you want to detect. You can select the desired columns. Bind Trigger The auto triggered node that triggers auto profiling. You must select an auto triggered node from the Bind Trigger drop-down list. You can view the IDs of auto triggered nodes in Operation Center. We recommend that you select the node that generates the current table. After you select the metrics based on which you want to detect the table data and submit the auto profiling task, the system runs the auto profiling task to detect the latest partition in the table after the auto triggered node is successfully run.
Estimated Cost The estimated cost for running the data profiling task. The cost is estimated based on the settings of the preceding parameters. Notice- To detect data in the MaxCompute table, you must execute MaxCompute SQL statements. In this case, you will be charged for using the MaxCompute service. The estimated cost is for reference only. The actual cost may vary based on the amount of data that is detected. You can check the bills for MaxCompute to view the actual cost.
- Features provided by Data Quality are used during data profiling. When you run a data profiling task, fees are generated in Data Quality and charged by DataWorks. For more information, see Overview.
- Select I understand that using this service will be charged.
- Click Commit.
- After the data profiling task is complete, view the data profiling results on the
Data Profiling tab.
You can select an option from the Profiling Records drop-down list to view the desired data profiling result.