DataWorks:MaxCompute table data

In the Table Basic Information section on the left side of the table details page, you can view information such as the table’s view count, read count, and favorite count.

• View count: The number of views of the table's details page in Data Map over the past 30 days. This data is calculated offline and has a T+1 delay.

• Read count: The number of times the MaxCompute table is read by tasks in the production environment over the past 30 days. The supported task types include SQL, Tunnel Download, data integration, and API-based data services. Only tasks that are associated with scheduling are counted. Reads from tasks that are not created in DataWorks are not included. This data is calculated offline and has a T+1 delay.

• Favorite count: The number of users who have added the table to their favorites. This data is updated in near real-time.

• Output task: The ID of the DataWorks recurring schedule task that writes data to this table. If the table is periodically updated but no task ID is displayed, the updates may be from tasks that are not created in DataWorks. You can contact the table owner for more information. This data is calculated offline and has a T+1 delay.

  Note

  If you do not have the permissions to view the code of the output task, you can contact the administrator of the workspace where the task resides to request the permissions. For more information, see Enable secure isolation for code and logs.

• Storage size: The logical storage size of the table. This data is calculated offline and has a T+1 delay.

• Health Status: The rating level of the table’s Data Health > Data Asset Governance > governance health score. This score helps you determine whether the table requires governance.

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

You can click Details to view the field information, partition information, and change records of the table.

• Field Information

  You can view the field information of the table. If the table is a partitioned table, you can also view its partition field information.

  Actions	Description
  Edit	Click to edit a field’s description, business description, security level, and primary key. You can use Copilot to generate field descriptions intelligently. Note Only workspace administrators and the table owner can edit table fields. To grant this capability, assign workspace administrator permissions. For details, see Global module permission control. The security level appears only for tables with individually configured field security levels. You can set field security levels here only after enabling the feature in the MaxCompute engine. For setup details, see Label-based access control.
  Recommended Field Desc	Batch-generate descriptions for columns that lack descriptions.
  Batch edit security level	Batch-set security levels for table fields to enhance data security.
  Upload	Click to drag and drop a local file into the Batch Upload Field Information dialog box. Note Only workspace administrators and the table owner can upload data to the target table. To grant this capability, assign workspace administrator permissions. For details, see Global module permission control. Only .xlsx files (Excel 2007 format) are supported. You can also download a template file. This feature is not supported for model tables generated by Smart Modeling.
  Download	Click to download the current table’s field information directly.
  Generate SELECT	After you click, in the Generate Select Statement dialog box, you can view or Copy the select statement for the current table.
  Generate DDL	Click to view or copy the current table’s DDL statement in the Generate DDL Statement dialog box.

  Note

  • Field popularity: This parameter is calculated based on the number of times the field is used in SQL join operations on the previous day. The number of times is proportionally converted into a rating of 0 to 5 stars.

  • Associated metrics: The model metrics that are associated with the field. To create or update associations, you can go to the Dimensional Modeling page, navigate to the editing page of the target table, and then manage the relationships between fields and metrics in the Field Management section. The associations take effect after you publish the modeled table.

• Partition Information

  You can view partition details, such as the partition name, record count, and storage size.

  Note

  • The record counts and sizes of partitions are for reference only. The updates of these values may be delayed. You can refer to the engine for the actual values.

  • For MaxCompute transactional tables, the Number of Records parameter is not supported and is always displayed as -1. You can run the SELECT COUNT(*) FROM <table_name> WHERE <partition>; command to obtain accurate results.

• Change records

  You can view the change description, change type, and granularity of the current table.

  In the upper-left corner of the Change Records tab, you can select a change type from the drop-down list to view its associated records.

Lineage information is generated by parsing real data flows, such as scheduled jobs and data synchronization jobs, to show the relationships between tables and fields. On the lineage page, you can view the upstream and downstream dependencies of tables or fields, trace the original data source, identify the final destination databases, and perform impact analysis across different lineage levels.

• View Table Lineage

  

  On the Table Lineage tab, you can view the detailed lineage of the current table. The following information is provided:

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

  • You can click a node and enter a keyword in the floating panel that appears to view all downstream tables that contain the keyword. You can also enter @+account_name to view all downstream tables that are owned by the specified account.

  • You can click + or - on the lineage graph to expand or collapse upstream or downstream nodes as required.

• View Field Lineage

  

  On the Field Lineage tab, you can view the detailed lineage of the target field. The following information is provided:

  • You can switch fields in the Change Field area to view the lineage of the selected field.

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

  • You can click + or - on the lineage graph to expand or collapse upstream or downstream nodes as required.

• Impact Analysis

  If the schema or data of a table changes, downstream nodes may be affected. You can use the Impact Analysis feature to identify the affected downstream tables in advance. You can filter the results by lineage level, task type, or table type, and download the analysis results to your on-premises machine.

  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 allow you to quickly view the governance health score of the table, the trend of pending governance issues, and specific governance items. You can resolve pending issues directly from the list of governance items.

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

  • Pending governance issue trend: The historical changes in the number of pending governance issues. This helps you understand the governance history of the table.

  • Governance items: The current governance issues. You can click an issue name in the Governance Items list or click the button in the Actions column to go to the Data Asset Governance > Overview > Governance Work Items page and handle governance work items.

• The data quality status lets you view the configured monitoring rules and the generated data quality alerts for the table.

You can view the Usage Records of the table from two dimensions: Frequently Associated and Access Statistics.

• Frequently Associated: The number of users who are using the data of the current table.

  Note

  The number of times the table is used as a join condition in computations over the past 30 days. This data is calculated offline and has a T+1 delay.

• Access Statistics: The usage records displayed in charts.

  • Read trend chart: Each date on the line chart indicates the read count for that day. Read counts in the development environment and production environment are distinguished. The number of field associations depends on how many times the field appears in the code and how many times the task runs. This data is calculated offline and has a T+1 delay.

    For example, if a field appears once in a task that runs twice, the count is 2. If the field appears twice in the code and the task runs once, the count is 2.

  • Field references in clauses: The number of times a field is used in SQL clauses, such as `where`, `select`, `join`, and `groupBy`. This data is calculated offline and has a T+1 delay.

  • Top readers: The users who read the table in SQL over the past 30 days. These users include both tenant accounts that are used in scheduling and individual accounts. Read operations include `where`, `select`, `join`, and `group by` on fields. This data is calculated offline and has a T+1 delay.

Data insights analyze the data structure and values to show statistics and distributions. You can create a new data insight directly on this page or go to the DataAnalysis module to perform data insights.