All Products
Search
Document Center

Dataphin:Logical view and field details

Last Updated:Mar 05, 2025

This topic explains how to access details of logical views and field assets.

Limits

Viewing logical view asset details is not supported when using Impala as the compute engine.

Logical view details entry

  1. On the Dataphin home page, go to Administration > Asset Checklist in the top menu bar.

  2. Select the Table tab. You can filter the target assets by owner, my responsibility, asset tags, project, environment, data section, subject area, table type, and storage format.

  3. In the list of logical views, select the desired view name or click the Actions column's image icon to open the object details page.

Logical view details

image

Area

Description

Overview

Displays information such as the type, environment, name, tags, and description of the table. You can also perform the following operations:

  • Search for other asset objects: You can quickly search and switch to view details of other assets.

  • View Asset Details: If the current object is listed in the Asset directory, you can quickly jump to the directory details page to view the listed information.

  • View Production/development Objects: Supports quick switching to view the object details in the corresponding production/development environment.

  • Tag: Displays the configured tag values of the current asset. To modify tags, you can click Edit:

    • The length of each tag value does not exceed 128 characters.

    • Each asset object can be configured with up to 20 tag values.

    • Super administrators can modify asset tags for all table types. The current table owner can modify asset tags for tables they own. Section architects can modify asset tags for logical views under their responsible sections.

  • Favorite: Click to add to or remove from favorites. After adding to favorites, you can view the last 30 favorited assets in Asset checklist - My Footprint for easy subsequent queries. You can also view all favorited assets in the Personal Data Center. For more information, see the referenced document.

  • Request Permission: Click to quickly jump to the permission request page for the current table. For more information, see the referenced document.

  • Generate Select Statement: Click to generate the current table query statement. You can choose whether to add escape characters. You can copy the query statement to the ad hoc query or analysis page to query data.

  • Export Fields: Export field information in the table in CSV format for quick analysis and use by other developers or business personnel.

  • View Change Owner Records: Click More in the upper right corner and select View Change Owner Records to display the last 100 change owner records for the current data table.

  • View Permission List: Click More in the upper right corner and select View Permission List to view data table permission information.

Note

For analysis platform tables, requesting permission, viewing change owner records, and viewing permission list operations are not supported.

Detail information

Displays detailed information about the table and fields.

  • Detail: Displays the technical property information of the table, including data section, subject area, project, highest sensitivity level, whether it is a partitioned table, whether it is a manually created table in the analysis platform, storage size, lifecycle, and location.

    • Project: The project information to which the current table belongs. Click the project name to jump to the asset details page of the project.

    • Highest sensitivity level: The highest sensitivity level of the current table fields, which helps quickly understand the data confidentiality of the current table. Data classification levels range from low to high as L1, L2, L3, L4 (public to top secret), and custom data classification.

    • Storage size: The actual storage size of the current table, updated T+1.

    • Lifecycle: The retention time of the current table, in days. When the compute engine is Databricks, the lifecycle is not displayed.

  • Field Information: Includes field details, description, data type, associated standards (requires purchasing the data standard module), data classification (requires purchasing the security module), data classification (requires purchasing the security module), and popularity information. You can also click the data lineage Actionsimage icon in the column to view the field lineage centered on the specified field.

    Note

    When the compute engine is Databricks, popularity information is not displayed.

Lineage & impact

  • Lineage displays the data lineage between tables and fields.

    • Table-level lineage sources include integration sync tasks, custom lineage compute tasks, and SQL compute tasks and logical table tasks that the system can automatically parse lineage. For more information, see the referenced document.

    • Field lineage sources include custom lineage compute tasks and SQL compute tasks and logical table tasks that the system can automatically parse lineage, excluding integration sync tasks. For more information, see the referenced document.

      Note

      The system parses the table and field lineage relationships in the development environment when tasks are submitted and in the production environment when published. A single task submission or publication supports parsing up to 100,000 lineage relationships. If exceeded, they are not recorded and cannot be displayed in the asset directory.

  • Impact is divided into data table impact and integration sync impact.

    • Data table impact: Displays direct downstream tables that reference the current table and indirect downstream tables that reference direct downstream tables. Supports exporting data and displaying only direct downstream tables.

      • Export Data: Supports exporting to Excel for business personnel to browse.

      • Display Only Direct Downstream Tables: When selected, only the downstream tables directly affected by the current table are displayed by default. When deselected, all downstream impact tables are displayed, up to 15 levels (starting from the direct downstream of the current table as the first level).

    • Integration sync impact: Displays integration sync tasks where the current table and downstream tables are used as source tables. Supports exporting data and displaying only the current table impact.

      • Export Data: Supports exporting to Excel for business personnel to browse.

      • Display Only Current Table Impact: When selected, only the integration tasks where the current table is used as an input table are displayed by default. When deselected, integration tasks where the current and all downstream impact tables are used as input tables are displayed, up to 15 levels (starting from the direct downstream of the current table as the first level).

Data preview

If you have the permission to query data in the current table, you can use the data preview feature to query only the results corresponding to fields for which you have select permission. You can preview the first 50 data entries. For information on how to request permission, see the referenced document.

You can search or filter the filtered data by field, search, view single row data details, perform automatic column width adjustment and row-column transformation operations. You can also click the sort icon after the field to perform No Sort, Ascending, or Descending operations. Double-click the field value to copy the field value with one click.

Note

When the compute engine is StarRocks, partition information is not displayed.

If the field type is HLL (HyperLogLog), the field information preview cannot be displayed temporarily.

Output information

Output tasks include data write tasks for the object, lineage automatic parsing or custom configuration tasks with the current table as the output table, and tasks where the node output name equals the project name.table name.

The output task list is updated in near real-time, and the output details are updated T+1.

image.png

  • ① View Output Details: Only supports viewing the output details of periodic tasks. For more information, see the referenced document.

  • ② Go To Operation: Click the Go To Operation button to jump to the task list page of the operation center and filter out the current task for more information.

Usage instructions

You can add usage instructions to the data table to provide information references for data viewers and consumers. You can click Add Usage Instructions to fill in the usage instruction title and content to complete the addition. image

Asset information

Displays detailed information such as the Basic Information, Change Information, and Usage Information of the physical table.

  • Basic information: Includes environment, table type, creation time, creator, owner, and output tasks.

    • Owner: The owner of the current table. Supports transferring the owner of the current table to other users. In the Change Owner dialog box, you can choose whether to synchronize the transfer of the development/production environment table. After selecting the Recipient, click OK to transfer immediately. It is recommended to synchronize the recipient promptly after the transfer. You can view transfer information on the transfer records page. For more information, see the referenced document.

      Note
      • Super administrators can transfer the owner of all table types. The current table owner can transfer tables they own.

      • Section architects support transferring the owner of logical views under their responsible sections.

    • Output Task: You can view single-pipe table output tasks, including data write tasks for the object, lineage parsing or configuration tasks with the current table as the output table, and tasks where the node output name equals the project name.table name. Click the name of the output task to jump to the operation details page of the data table.

      Note

      Only supports viewing the output details of periodic tasks.

  • Change information: Includes last accessed, DDL changes.

    • Last Accessed At: The last select time (corresponding to DQL operation) parsed by Dataphin based on SQL. Access triggered by external systems is not counted and is updated in real-time.

    • Last Ddl Time: The last table structure change time (corresponding to DDL operation) parsed by Dataphin based on SQL. Changes triggered by external systems are not counted and are updated in real-time.

  • Usage information: Includes number of favorites, page views, and visits.

    • Number Of Favorites: Displays the number of users who favorited the current table, updated in real-time.

    • Page Views: Displays the page views (PV) of the current data table. Each refresh increases by one, updated in real-time.

    • Visits: Calculated as one time when the table is selected (corresponding to DQL operation) in Dataphin tasks based on SQL parsing. Updated T+1, displaying the total number of visits in the last 30 days.

      Note

      When the compute engine is Databricks, visit information is not displayed.

Field details

This section presents the table details where the current field is located. For more information, see the referenced document .