Track Logical Table Dependencies and Related Objects - Dataphin - Alibaba Cloud - Dataphin

View and manage the related objects of a logical table, including associated logical tables, input tables, and computation or integration tasks that reference the current table.

Logical table related objects entry

On the Dataphin home page, single click the top menu bar Developer. You will be directed to the data Development page by default.
On the data Development page, use the following steps to select the logical table whose related objects you wish to view and manage, and navigate to the logical table related objects management page:

Single click Dimension/Fact logical table -> single click to select the desired logical table -> single click Related.

Introduction to logical table related objects

The related objects page shows the associated logical tables, input tables, and downstream tasks of the current logical table.

View associated logical tables

Associated dimensions reference other logical tables from the current table.

Note

Note: Only dimension logical tables can be associated as logical tables.

Area

Description

①Search and filter area

Filter: Filter associated logical tables by logical table type and development status.
- Logical Table Type: Includes common dimension logical table, hierarchical dimension logical table, event fact logical table, snapshot fact logical table, flow fact logical table, and aggregate logical table.
- Development Status: Includes draft, submitting, submitted, and developing.
Search: Search for associated logical tables by name.

If the associated logical table you need is not displayed, click to refresh the list.

②Associated logical list

Lists the logical tables linked to the current logical table and the available operations.

Table information: Displays the logical table name, Chinese name, type, and development status.
Operation: Single click to view the associated logical table.

View input tables

Input tables are tables read by the current table, as defined in the source configuration of the current logical table's computation logic.

Note

Logical tables for virtual and enumeration dimensions do not support input tables.
The source for a hierarchical dimension logical table is the root physical table, rather than any intermediate tables.

Area

Description

①Search and filter area

Filter: Filter input tables by table type, including dimension logical table, hierarchical dimension logical table, fact logical table, aggregate logical table, and physical table.
Search: Search for input tables by name.

If the input table you need is not displayed, click to refresh the list.

②Input table list

Lists the input tables of the current logical table and the available operations.

Table information: Includes the table name, Chinese name, and type.
Operation: Single click to view the input table.

View dependent objects

Dependent objects of the logical table include public calendars and global variables.

Public calendar

Area

Description

Refresh

Single click to update the public calendar list.

Public Calendar List

Lists the public calendar objects related to the current logical table and the available operations.

Object information: Includes the associated public calendar encoding, name, and reference method.
Operation: Single click to view the associated public calendar.

Global variables

Area

Description

Refresh

Single click to update the global variable list.

Global variable list

Lists the global variable objects related to the current logical table and the available operations.

Object information: Includes variable encoding and name.
Operation: Single click to view the associated global variables.

View downstream tasks

Downstream tasks refer to computation or integration tasks and logical tables that depend on the current logical table, where the current table serves as the input for these tasks.

Area	Description
①Search and filter area	Filter: Filter downstream tasks by node type, reference parameters, node project/section, schedule cycle, and owner. Search: Search for downstream tasks by node ID or task name. If the downstream task you need is not visible, click to refresh the list.
②Downstream task list	Lists the tasks that depend on the current logical table and the available operations. Downstream task information: Shows the downstream node name/ID, node type, associated project/section, schedule cycle, and owner. Operation: To view the downstream tasks, single click .
③Dependent fields	Includes All fields and A specific field, showing the downstream tasks associated with each. All fields: Lists all downstream task nodes of the current logical table's fields. A specific field: Click a dependent field to view tasks that rely on that field.