DataWorks:MaxCompute table data

In the Basic Table Information area on the left side of the table details page, you can view information such as View Count, Read Count, and Favorite Count.

• Views: The number of times the table details page has been viewed in Data Map in the last 30 days. This data is collected offline and is subject to a T+1 delay.

• Reads: The number of tasks that read the MaxCompute table in the production environment in the last 30 days. The task types include SQL, Tunnel Download, data integration, and DataService Studio APIs. Currently, only reads from tasks associated with scheduling are counted. Reads from tasks not managed by DataWorks are not counted. This data is collected offline and is subject to a T+1 delay.

• Favorites: The number of times the table has been added to favorites. This data is collected in near real-time.

• Output Task: The ID of the recurring DataWorks scheduling task that writes to the current table. If the table is periodically updated but no task ID is displayed, the write operation may be performed by a recurring scheduling task not managed by DataWorks. Contact the table owner for more information. This data is collected offline and is subject to a T+1 delay.

  Note

  If you do not have permission to view the code of the output task, contact the administrator of the workspace where the task is located to grant you the required permissions. For more information, see Enable code and log isolation.

• Storage Size: The logical storage size of the table. This data is collected offline and is subject to a T+1 delay.

• Health Score: Displays the rating of the table's Data Health > Data Governance > Governance Health Score. You can use this score to determine whether the table requires governance.

• Table description: A description of the table. You can use Copilot to intelligently generate the description.

Click Details to view the table's Field Information, Partition Information, and Change History.

• Field information

  You can view the table's field information. If the table is a partitioned table, you can also view the Partition Field Information.

  Operation	Description
  Edit	After you click, you can edit the field's Description, Business Description, Security Level, and Primary Key. You can use Copilot to auto-generate the field description. Note Only Space Administrators and table owners can edit table fields. If a target user needs to edit table fields, you can grant the Space Administrator permission. For more information, see Global-level module access control. The Security Level is displayed only for tables with individually set field security levels. You can set the security level of table fields here only after you enable the field security level feature for the MaxCompute engine. For more information about how to enable the security level feature, see Label-based access control.
  Recommend field descriptions	Batch generate descriptions for fields that do not have one.
  Batch Edit Security Levels	Batch set the security level for table fields to improve data security.
  Upload	After you click, drag your local data into the Batch Upload Field Information dialog box. Note Only Workspace Administrators and table owners can upload data to the target table. If a user needs to upload data, you can grant the Workspace Administrator permission. For more information, see Global-level module access control. Only .xlsx (Excel 2007) files can be uploaded. You can also Download The Template File. This feature is not supported for model tables generated by intelligent modeling.
  Download	Click to download the current table's field information.
  Generate SELECT	After you click, you can view or Copy the select statement for the current table in the Generate Select Statement dialog box.
  Generate DDL	After you click, you can view or Copy the table creation statement for the current table in the Generate DDL Statement dialog box.

  Note

  • Field popularity: This metric is based on the number of times the field was used in a `JOIN` clause of an SQL statement on the previous day. The popularity is represented as a star rating from 0 to 5, where 5 is the highest.

  • Associated metrics: Displays the model metrics associated with the field. To create or update associations, go to Dimensional Modeling. On the editing page of the target table, use the field management feature to maintain the associations between fields and metrics. After you publish the model table, the associations are applied.

• Partition information

  You can view partition information for the current table, such as Partition Name, Record Count, and Storage Size.

  Note

  • The partition record count and size are for reference only, and data updates may be delayed. For accurate values, refer to the data in the engine.

  • If the table is a MaxCompute transactional table, the Record Count is not supported and is always displayed as -1. The SELECT COUNT(*) FROM <table_name> WHERE <partition>; command provides the accurate value.

• Change history

  You can view the change records for the current table, such as Change Description, Change Type, and Granularity.

  In the upper-left corner of the Change Records tab, you can filter the records by change type.

Lineage shows the relationships between tables and fields. Lineage is derived by parsing the actual data flows from scheduling jobs, data synchronization, and other processes. On the lineage page, you can view the upstream and downstream nodes of a table or field, trace the original source of table data, and identify the final destination database. You can also analyze the impact of changes across different lineage levels.

• View table lineage

  

  On the Table Lineage tab, you can view the lineage details for the current table. Key features are as follows:

  • You can view the number of upstream and downstream nodes for each node in the table lineage. You can hover over a table or task type to view its basic information.

  • When you click a node, a floating panel appears. In the lineage association section of this panel, you can enter a keyword to display all downstream tables that contain the keyword. You can also enter @+account_name to display all downstream tables under that account.

  • You can click + or - in the lineage graph to expand or collapse upstream and downstream nodes.

• View field lineage

  

  On the Field Lineage tab, you can view the lineage details for the target field. Key features are as follows:

  • In the Switch Field area, you can switch between fields of the current table to view the corresponding field lineage graph.

  • You can view the number of upstream and downstream nodes for each node in the field lineage. You can hover over a field or task type to view its basic information.

  • You can click + or - in the lineage graph to expand or collapse upstream and downstream nodes.

• Impact analysis

  If the schema or data of the current table changes, downstream nodes are affected. You can use Impact Analysis to identify downstream tables and predict which ones might be affected by a change. On this page, you can filter by criteria such as lineage level, task type, and table type to display the downstream tables that meet the specified conditions. You can also download the analysis results.

  Note

  You can analyze up to 50 levels of table lineage.

You can view the data governance details and data quality status of the table.

• The data governance details provide a quick view of the table's governance health score, the trend of governance issues, and specific governance issues. This lets you quickly resolve governance issues.

  • Health Score: A quantitative assessment of the table across five dimensions: storage, compute, development, quality, and security. The score reflects the effectiveness of governance. A higher score indicates better governance.

  • Trend Of Issues Requiring Governance: Shows the historical trend of governance issues, helping you understand the table's governance history.

  • Governance Item Issues: Displays a list of issues that need to be addressed. You can click an issue name in the Governance Item Issues column or the Handle button in the Actions column to go to Data Asset Administration > Overview > Governance Work Items to handle governance work items.

• The data quality status shows the rule details for the table and any generated Data Quality alerts.

This page displays the Usage Records for the table based on the Frequent Association and Access Statistics dimensions.

• Frequent Associations: Shows the number of users who are using the data in the current table.

  Note

  This is the number of times the table was used in a join condition for calculations in the last 30 days. This data is collected offline and is subject to a T+1 delay.

• Access Statistics: Displays the table's usage records in charts.

  • Read Trend Chart: The line chart shows the number of reads per day and distinguishes between reads from developer and production environments. The number of field associations is related to the number of task executions and the number of times the field appears in the code. This data is collected offline and is subject to a T+1 delay.

    For example, if a field appears once in a task that is executed twice, the count is 2. If a field appears twice in the code, a single task execution results in a count of 2 for that field.

  • Field References In Clauses: Shows statistics on the number of times a field is used in SQL statements, such as in `WHERE`, `SELECT`, `JOIN`, and `GROUP BY` clauses. This data is collected offline and is subject to a T+1 delay.

  • Top Readers: Shows statistics on the users who have read the table in SQL in the last 30 days. This includes access by tenant accounts used for scheduling and individual accounts. Read operations include `WHERE`, `SELECT`, `JOIN`, and `GROUP BY` clauses that reference the fields. This data is collected offline and is subject to a T+1 delay.

EBS Lens analyzes the structure and values of your data to display statistics and data distribution. You can create an EBS Lens directly on the current page or go to the DataAnalysis module to perform EBS Lens.