All Products
Search
Document Center

DataWorks:Obtain a panoramic view of a table

Last Updated:Aug 15, 2023

You can view the information about a MaxCompute table in the following sections on the Table 360 page of the Toolbox module to obtain a panoramic view of the table: Basic information, Governance issues, Related baseline, Task execution information, Indicator trend, and Event Record. This topic describes the features that are provided on the Table 360 page.

Limits

  • You can perform data governance only on tables in a MaxCompute project.

  • If you log on to the DataWorks console by using an Alibaba Cloud account or as a RAM user to which the AliyunDataWorksFullAccess policy is attached, you can select any workspace. If you log on to the DataWorks console as a RAM user to which the AliyunDataWorksFullAccess policy is not attached, you can select only workspaces in which you are assigned the Workspace Manager role. For more information about how to attach the AliyunDataWorksFullAccess policy to a RAM user, see User permission management.

Obtain a panoramic view of a table

  1. Log on to the DataWorks console. In the left-side navigation pane, choose Data Governance > Data Governance Center. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Governance Center.

  2. On the Data Governance Center page, click the Workbench tab. In the left-side navigation pane of the page that appears, click Table 360.

  3. In the upper part of the page, select a project from the Project drop-down list and select a table in the project from the Table drop-down list.

    Important

    If you log on to the DataWorks console by using an Alibaba Cloud account or as a RAM user to which the AliyunDataWorksFullAccess policy is attached, you can select any workspace. If you log on to the DataWorks console as a RAM user to which the AliyunDataWorksFullAccess policy is not attached, you can select only workspaces in which you are assigned the Workspace Manager role. For more information about how to attach the AliyunDataWorksFullAccess policy to a RAM user, see User permission management.

  4. On the Table 360 page, view the information about the table in the following sections: Basic information, Governance issues, Related baseline, Task execution information, Indicator trend, and Event Record.

Table 360

Section

Description

1

The Basic information section displays the basic information about the table, including the time information, specifications, partition information, and node information.

2

The Governance issues section displays the status of each governance issue that occurs on the table and the scores deducted due to the governance issues. You can perform the following operations to handle governance issues:

  • Click the name of a governance issue or click Handling in the Operation column of the governance issue. You are redirected to the Governance issues page of the Workbench tab to handle the governance issue.

    Note

    For more information about governance issues, see Handle governance issues.

  • Click the name of a governance item. You are redirected to the details page of the governance item on the Knowledge Base tab. On the details page, you can view the details of the governance item from the dimensions of associated governance issue, rule judgment, handling guide, and precautions.

3

The Related baseline section displays all baselines to which the current node belongs and the execution details of each baseline on the current day. The details of a baseline include the baseline name, priority, status, committed point in time, and alert time. You can click the name of a baseline to go to the Smart Baseline page to view the execution details of the baseline.

Note

For more information about the intelligent baseline feature, see Overview.

Table 360

Section

Description

4

The Task execution information section.

This section displays the basic information about the instance execution of the current node in the latest 32 days. You can search for node instances by using the following filter conditions: Instance ID, Execution status, and Operation Type. You can sort node instances based on Business Date, Timing time, Start time, End time, or Running time.

  • Select a node from the Node drop-down list to view the details of the instances that are generated for the node.

  • Click View details in the Operation column of a node instance to go to the Cycle Instance page in Operation Center to view the details of the instance.

5

The Indicator trend section.

This section displays the trend chart for the execution duration, start time, end time, or time consumed to wait for the scheduling time of a data synchronization node. The trend chart uses time as the X-axis.

  • Click View details to go to the Resource Details page of the Usage Analysis page to view the consumption details of MaxCompute computing and storage resources and DataWorks scheduling and Data Integration resources for the node in the specified workspace during a specified period.

  • Select a state from the Task status drop-down list to search for your desired node instances.

6

The Event Record section.

This section displays the data governance operations that you performed on the current table and the details of each governance issue, including the time at which the governance issue is identified, owner, and scores that are deducted due to governance issues.