Logical view and field details

更新时间:
复制 MD 格式

This topic describes how to view the details of logical view and field assets.

Access logical view details

  1. On the Dataphin homepage, choose Administration > Asset Checklist in the top menu bar.

  2. Click the Table tab. You can filter assets by owner, assets that you own, asset tags, project, environment, data section, subject area, table type, and storage format.

  3. In the logical view list, click the name of the target view or the image icon in the Actions column to open the object details page.

Logical view details

image

Area

Description

Summary

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

  • Search for other asset objects: Quickly search for and switch to the details of other assets.

  • View asset details: If the current object is listed in the Asset Catalog, you can go to the catalog details page to view the listing information.

  • View production/development object: Quickly switch to the details of the current object in the corresponding production or development environment.

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

    • Each tag value can be up to 128 characters long.

    • You can configure a maximum of 20 tag values for each asset object.

    • A super administrator can modify asset tags for all table types. The table owner can modify asset tags for tables they own. A data section architect can modify asset tags for logical views in the data sections they manage.

  • Favorite: Click to add to or remove from favorites. After you add an asset to your favorites, you can view the 30 most recently favorited assets in Asset Checklist - My Footprints for easy access. You can also view all your favorited assets in the Personal Data Center. For more information, see View and manage my favorited assets.

  • Request Permission: Click to go to the permission request page for the current table. For more information, see Request, renew, and return table permissions.

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

  • Export Fields: Export the field information from the table in CSV format. This makes it easy for other developers or business users to quickly analyze and use the data.

  • View Transfer Records: In the upper-right corner, click More and select View Transfer Records to display the 100 most recent owner transfer records for the current data table.

  • View Permission List: In the upper-right corner, click More and select View Permission List to view the data table's permission information.

Note

The request permission, view transfer records, and view permission list operations are not supported for analysis platform tables.

Details

Displays detailed information about the table and its fields.

  • Detail: Displays the technical properties of the table, including data section, subject area, project, highest sensitivity level, whether it is a partitioned table, whether it is a manual table on the analysis platform, storage size, lifecycle, and location.

    • Project: The project to which the current table belongs. Click the project name to go to the project's asset details page.

    • Highest sensitivity level: The highest sensitivity level among the table's fields. This helps you quickly understand the data confidentiality of the table. Data classification levels range from L1 (Public) to L4 (Top Secret), in addition to custom data classifications.

    • Storage size: The actual storage size of the table. This is updated on the next day (T+1).

    • Lifecycle: The retention period of the table, in days.

  • Source table columns: Includes field details, description, data type, associated standard (requires the Data Standard module), data classification (requires the Data Security module), sample data (displayed only if the Data Sampling feature is enabled), data classification (requires the Data Security module), and heat information. You can also search for, filter, and view the lineage of fields.

    • View lineage: In the Actions column, click the lineage image icon to view the field lineage centered on the specified field.

    • Search and filter: You can search for fields by name or description. You can also filter fields by data classification and data classification level (requires Data Security).

  • Associated assets: The associated dimension information for the current table. Click a table name to go to its details page.

Lineage & Impact

  • Lineage displays the lineage between tables and fields.

    • Table lineage sources include sync tasks, SQL compute nodes, and logical table tasks for which the system can automatically parse lineage. It also includes custom lineage manually configured for compute nodes . For more information, see Table lineage.

    • Field lineage sources include sync tasks (field-level lineage can be parsed for only some data sources), SQL compute nodes, and logical table tasks for which the system can automatically parse lineage. It also includes custom lineage manually configured for compute nodes . For more information, see Field lineage.

      Note
      • For system-parsed lineage and manually configured lineage in compute nodes, the table and field lineage for the development environment is parsed when the node is submitted. The table and field lineage for the production environment is parsed when the node is published. A maximum of 100,000 lineage relationships can be parsed when a single node is submitted or published. If this limit is exceeded, the lineage is not recorded and cannot be displayed in the Asset Checklist.

      • Deleting a logical table also deletes its associated lineage.

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

    • Data table impact: Displays the child tables that reference the current table and the indirect descendant tables that reference the child tables. You can export data and show only child tables.

      • Export Data: You can export the data as an Excel file for business users to view.

      • Show only child tables: When selected, only the downstream tables directly affected by the current table are displayed. When cleared, all affected downstream tables are displayed, up to 15 levels. The child tables of the current table are considered the first level.

    • Sync impact: Displays the sync tasks where the current table and its descendant tables are used as source tables. You can export data and show only the impact of the current table.

      • Export Data: You can export the data as an Excel file for business users to view.

      • Show only current table impact: When selected, only the sync tasks where the current table is an input table are displayed. When cleared, the sync tasks where the current table and all its affected descendant tables are input tables are displayed, up to 15 levels. The child tables of the current table are considered the first level.

Data profiling

If you have enabled the Data Quality feature, you can configure data profiling tasks for a data table to quickly get an overview of the data and assess its availability and potential threats in advance. To enable automatic profiling, you can configure the settings in Administration > Metadata Center > Profiling and Analysis. For more information, see Create a data profiling task.

Data preview

If sample data exists for the data table, the sample data is displayed by default. You can also manually trigger a query to get the latest data. If no sample data exists, a data preview query is automatically triggered.

  • Sample data: Displayed when the data sampling switch and the data preview switch in the usage configuration are both turned on. Only sample data for fields that do not require masking and for which you have column-level permissions is queried. The sample data for each field is stored, sorted, and displayed independently, but the existence and correctness of row records are not guaranteed.

  • Data preview: If you have permission to query data in the current table, you can use the data preview feature. Only the results for fields for which you have permissions for SELECT statements, including field-level and row-level permissions, are queried. You can preview the first 50 data records. For information about how to request permissions, see Request, renew, and return table permissions.

For the filtered data, you can find or filter by field, search, view single-row data details, use automatic column width adjustment, and perform row-column transposition. You can also click the sort icon after a field to perform No sorting, Ascending, or Descending operations. Double-click a field value to copy it.

Note

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

Output information

Output tasks include data writing tasks for the object, tasks where the current table is the output table based on automatic lineage parsing or custom configurations, and nodes where the output name is in the format of `Project name.Table name`.

The output task list is updated in near real-time. The output details are updated on the next day (T+1).

image.png

  • ① View output details: You can view output details for auto triggered tasks only. For more information, see Output details.

  • ② Go To O&M: Click the Go To O&M button to open the task list page in the Operation Center. The page is filtered to display more information about the current task.

Usage instructions

You can add usage instructions for a data table to provide information for data viewers and consumers. Click Add Usage Instructions, enter a title and content, and then the instructions are added.image

Asset information

Displays details for the physical table, such as Basic Information, Change Information, and Usage Information.

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

    • Owner: The owner of the current table. You can change the owner of the current table to another user. In the Change Owner dialog box, you can choose whether to simultaneously change the owner of the table in the development or production environment. After you select a Recipient, click OK to immediately transfer ownership. We recommend that you promptly sync with the recipient after the transfer. You can view transfer information on the transfer records page. For more information, see View transfer records.

      Note
      • A super administrator can change the owner for all table types. A table owner can change the owner for tables they own.

      • A data section architect can change the owner of logical views in the data sections they manage.

    • Output Task: You can view the output tasks for a single table. These include data writing tasks for the object, tasks where the current table is the output table based on lineage parsing or configuration, and nodes where the output name is in the format of `Project name.Table name`. Click the name of an output task to go to the O&M details page for that data table.

      Note

      You can view output details for auto triggered tasks only.

  • Change information: Includes last accessed time and DDL changes.

    • Last Accessed At: The time of the most recent SELECT operation (corresponding to a DQL operation) parsed by Dataphin from SQL. Access triggered by external systems is not counted. This is updated in real-time.

    • Last Ddl Time: The time of the most recent schema evolution (corresponding to a DDL operation) parsed by Dataphin from SQL. Changes triggered by external systems are not counted. This is updated in real-time.

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

    • Number Of Favorites: The number of users who have favorited the current table. This is updated in real-time.

    • Page Views: The number of page views (PV) for the current data table. The count increases by one each time the page is refreshed. This is updated in real-time.

    • Visits: When a SELECT operation (corresponding to a DQL operation) on the table is parsed from a Dataphin node, it is counted as one visit. This is updated on the next day (T+1). The total number of visits in the last 30 days is displayed.

Field details

This section displays the details of the data table that contains the current field. For more information, see Logical view details.