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

  1. Log on to the DataWorks console.
  2. In the left-side navigation pane, click Workspaces.
  3. Find the target workspace and click Data Analytics in the Actions column.
  4. On the DataStudio page, click DataWorks icon in the upper-left corner and choose All Products > DataMap. The homepage of Data Map appears.
  5. In the top navigation bar, click All Data.
  6. On the All Data page, click a tab as needed, such as MaxCompute Table.
  7. On the tab that appears, click the name of the table you want to view.
    On the details page, 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 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.Basic Information section
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 Edit icon next to Description, enter a description in the text box that appears, and then click Save icon.
  • Add a tag to or remove a tag from the table: Click Add icon 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.

View business information

In the Business Information section, you can view the DataWorks workspace name, environment type, category, and display name of the table.Business Information section
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 Edit icon next to Display Name, enter a name in the text box that appears, and then click Save icon.

View permission information

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

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.Technical Information section
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.Field Information tab
    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 SELECT statement 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.Partitions tab
  • 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.Change Records tab

    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.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).Table Lineage tab
  • 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.Field Lineage tab
  • 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.Impact Analysis tab

    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.Foreign Key References tab
  • 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.Data Preview tab
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.Data Detection tab
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:
    1. On the Data Detection tab, click Manual Detection.
    2. In the Manual Detection dialog box that appears, set parameters as needed.Manual Detection dialog box
      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.
    3. Select I understand that using this service will be charged.
    4. Click Commit.
    5. 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:
    1. Turn on the Auto Detection switch.
    2. In the Auto Detection (When Partition Information Changes) dialog box that appears, set parameters as needed.Auto Detection 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.

      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.
    3. Select I understand that using this service will be charged.
    4. Click Commit.
    5. 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.Instructions tab