All Products
Search
Document Center

DataWorks:MaxCompute table data

Last Updated:Mar 26, 2026

After you bind a MaxCompute data source to DataWorks Data Studio, DataWorks automatically collects metadata from the engine—a one-time full collection on first bind, then incremental updates daily. All metadata flows into Data Map, where you can explore table details, trace data lineage, monitor governance health, manage access permissions, and analyze data usage patterns.

If a table doesn't appear in Data Map after binding, go to My Data > My Tools > Refresh Table Metadata to trigger a manual sync.

Prerequisites

Before you begin, make sure you have:

View table details

Click a table name in the search results to open its details page.

image.png

The details page is organized into the following sections:

SectionWhat you can do
Quick actionsRequest permissions, add to or view data albums, favorite the table, generate an API in DataService Studio, or query data in SQL Query
Table Basic InformationView count, read count, favorite count, lifecycle, approver, health status, table owner, and table type
Table model informationView data warehouse layer, business category, and storage policy for tables built with Smart Data Modeling; click View Model to open the Dimensional Modeling page
Table permission informationSee your current permissions; click View Details to go to the Table Permission Request page
Table technical informationView DDL Statement Updated At, Data Updated At, and Last Viewed At timestamps
DetailsExplore field information, partition information, and change records
Output informationView runtime details for the production task that writes to this table (T+1 delay)
Lineage informationTrace upstream and downstream dependencies within or across engines, and between the engine and output APIs; MaxCompute also supports end-to-end lineage from offline sync (real-time)
Data HealthCheck the governance health score, pending issue trends, and specific governance items
Data QualityView configured monitoring rules and the Data Quality Center (DQC) alert list; click Configure Rules to set up quality rules
Usage RecordsAnalyze table usage through Frequently Associated and Access Statistics dimensions
Data PreviewBrowse 20 random rows from the table
Data InsightRun statistical and distribution analysis on the table's data

View basic table information

The Table Basic Information section on the left side of the details page shows the following metrics:

  • View count: Number of views of the table's details page in Data Map over the past 30 days. T+1 delay.

  • Read count: Number of times the table is read by production tasks over the past 30 days. Counted task types: SQL, Tunnel Download, data integration, and API-based data services. Only scheduling-associated tasks are counted; reads from tasks not created in DataWorks are excluded. T+1 delay.

  • Favorite count: Number of users who have favorited the table. Updated in near real-time.

  • Output task: ID of the DataWorks recurring schedule task that writes data to this table. If the table updates periodically but no task ID appears, the updates may originate from tasks outside DataWorks—contact the table owner for details. T+1 delay.

    If you don't have permission to view the output task's code, ask the workspace administrator to grant access. See Enable secure isolation for code and logs.
  • Storage size: Logical storage size of the table. T+1 delay.

  • Health Status: The rating level derived from the table's governance health score under Data Health > Data Asset Governance.

  • Table description: Description of the table. Use Copilot to intelligently generate a description.

View details

Click Details to access field information, partition information, and change records.

Field information

The field information tab shows all columns in the table, including partition fields for partitioned tables.

ActionDescription
EditEdit a field's description, business description, security level, and primary key. Use Copilot to generate descriptions. Only workspace administrators and the table owner can edit fields.
Recommended Field DescBatch-generate descriptions for columns that have none.
Batch edit security levelSet security levels for multiple fields at once.
UploadDrag and drop an .xlsx file (Excel 2007 format) to batch-upload field information. Only workspace administrators and the table owner can upload. Not supported for model tables generated by Smart Modeling.
DownloadDownload the table's field information as a file.
Generate SELECTView or copy a SELECT statement for the table.
Generate DDLView or copy the table's DDL statement.
Field security levels appear only for tables with individually configured field-level security. To enable this feature, first configure it in the MaxCompute engine. See Label-based access control.
Field popularity is a 0–5 star rating calculated from how many times the field is used in SQL join operations on the previous day.
Associated metrics shows model metrics linked to the field. Manage these associations in the Dimensional Modeling page under Field Management—changes take effect after you publish the model table.
Only workspace administrators and the table owner can edit or upload field information. To grant this access, assign workspace administrator permissions. See Global module permission control.

Partition information

For partitioned tables, the partition information tab shows partition name, record count, and storage size.

Record counts and storage sizes are for reference only and may be delayed. Check the engine for authoritative values.
For MaxCompute transactional tables, Number of Records is not supported and always displays as -1. Run SELECT COUNT(*) FROM <table_name> WHERE <partition>; to get accurate counts.

Change records

The change records tab shows the change description, change type, and granularity for each modification to the table. Use the drop-down list in the upper-left corner to filter by change type.

View lineage information

Data lineage is generated in real time by parsing actual data flows—scheduled jobs and data synchronization jobs. It shows upstream and downstream dependencies at both the table and field level, letting you trace data origins, identify final destinations, and analyze impact before making changes.

Lineage is available in DataWorks Standard Edition and later.
Lineage from ad hoc queries or manual operations is not captured.
If lineage is missing for SQL run by a PyODPS node, manually configure DataWorks scheduling parameters in the PyODPS task code. See Develop a PyODPS 3 task and Develop a PyODPS 2 task.

Table lineage

image

The Table Lineage tab shows the full lineage graph for the current table:

  • Each node displays upstream and downstream counts. Hover over a table or task type to see its basic information.

  • Click a node to search its downstream tables by keyword or by @account_name.

  • Click + or - to expand or collapse lineage levels.

Field lineage

image

The Field Lineage tab shows column-level lineage:

  • Switch between fields using the Change Field selector.

  • Hover over a field or task type to see its details.

  • Click + or - to expand or collapse lineage levels.

Impact analysis

Use Impact Analysis to identify downstream tables affected by a schema or data change before making it. Filter results by lineage level, task type, or table type, then download the analysis.

Impact analysis supports up to 50 lineage levels.

View data health

The Data Health section covers two areas: governance health and data quality.

Governance health gives you a quantitative view of the table's asset quality across five dimensions: storage, computing, development, quality, and security. A higher score means better governance.

  • Health score: The overall score. Higher is better.

  • Pending governance issue trend: A historical view of how pending issues have changed over time.

  • Governance items: The list of current issues. Click an issue name or the action button to go to Data Asset Governance > Overview > Governance Work Items and resolve governance items.

Data quality shows the monitoring rules configured for the table and any active DQC alerts. Click Configure Rules to set up or update quality monitoring rules.

View usage records

Usage records help answer two common questions: who is using this table, and how frequently?

Frequently Associated shows the number of users who are using the current table's data. This is based on the number of times the table is used as a join condition in computations over the past 30 days. T+1 delay.

Access Statistics breaks down usage through charts:

  • Read trend chart: Daily read counts for the past 30 days, split by development and production environments. The count reflects how many times each field appears in task code multiplied by how many times the task runs—for example, a field referenced once in a task that runs twice counts as 2; a field referenced twice in a task that runs once also counts as 2. T+1 delay.

  • Field references in clauses: How many times each field is used in SQL clauses (WHERE, SELECT, JOIN, GROUP BY). T+1 delay.

  • Top readers: The users—tenant accounts used in scheduling and individual accounts—who have read the table via SQL in the past 30 days. T+1 delay.

View data preview

The data preview page shows 20 random rows from the table.

Important
  • Previewing data in the production environment requires table preview permissions. If you don't have them, see Request table permissions.

  • If Project Management Configuration in your workspace enables table preview permissions, you can preview data without explicit query permissions in Security Center.

  • If data masking rules are configured and active, they also apply on the preview page. See Create a data masking rule.

  • Data preview is not supported for MaxCompute foreign tables or tables containing JSON-type fields.

From the data preview page, you can also:

  • Click Preview in Workbook to open the data in a new workbook in DataAnalysis.

  • Click Data Analysis to open a new SQL Query (legacy) file in DataAnalysis, pre-filled with a query for this table.

After querying the table, you can run data insights, generate workbooks, or create cards and reports.

View data insights

Important

Data insights are not supported for tables with Schema syntax enabled.

Data insights analyze the data structure and values to show statistics and distributions. Create a new data insight directly on the table details page, or go to the DataAnalysis module to run data insights.

Request and manage table permissions

Use DataWorks Security Center to request and manage access to MaxCompute tables.

Request table permissions

  1. On the table details page, click Request Permissions.

    If the table is hidden, the Request Permissions button is not displayed.

    image.png

  2. Complete the request on the Permission Request page in Security Center. See MaxCompute data access control.

Manage table permissions

  1. In the left navigation pane, click My Data.

  2. Click Managed by Me. From there, update the table's lifecycle and Visibility, or perform operations such as Delete, Transfer, and Modify Category.

View permission approval records

Go to Security Center > Data Access Control to view permission approval details and approval history. See Data access control.

Manage MaxCompute tables

Manage tables using data albums

Add the table to a data album to group and manage it alongside related tables, or view the albums the table already belongs to. See Data albums.

Configure category navigation

In the left navigation pane of Data Map, go to Configuration Management > Category Management Configuration to set up category navigation for your MaxCompute tables. See Configuration management.