View data table asset details - Dataphin - Alibaba Cloud Documentation Center

Asset details are available only for listed assets. This topic describes the asset details for data mid-end tables and other system tables.

Prerequisites

The purchased Asset Operation value-added service is active, and the current tenant has activated the Asset Operation module.

Limits

When the data source type is PolarDB-X (formerly DRDS), SAP HANA, IBM DB2, OceanBase (MySQL, Oracle tenant mode), the data source table and its custom metrics do not support applying for consumption permissions.
When the table type is a data source table, you must configure the data source encoding before utilizing the data preview function. For information on configuring data source encoding, see Data Source Management.
For data sources that support data preview and data exploration functions, see Operations supported by different collection sources.

Table asset details

On the Dataphin homepage, select Asset > Asset Directory from the top menu bar.

Select the table asset tab and click the name of the target asset to access the asset details page.

Dataphin table asset details are generally consistent with other system table asset details. Below is an example using the Dataphin Data Table.

Area	Description
①Summary Information	Displays the name, type, highest confidentiality level (requires purchasing data security features), tags, statistic granularity, and description information of the data table. You can perform the following operations on the asset: View Metadata: Click View Metadata to jump to the details page of the asset checklist for this table. Search Asset: Supports quick search for other data tables, select the data table you want to view, and jump to the details page of the data table. Statistic Granularity: Displayed when the table type is a logical aggregate table and the table has fields with business type as dimension. Supports viewing information for each statistic granularity, including statistic granularity name, code, description, belonging section, and subject domain information. You can also perform the following operations: View Details: Click to jump to Planning > Data Architecture to view detailed information under the business entity tab. View Entity Relationship Diagram: Click to open the Entity Relationship Diagram panel to view the entity relationship diagram centered on that business entity. Favorite: Click to favorite or remove from favorites. After favoriting, you can also view all favorited assets in the Personal Data Center. For more details, see View and Manage My Favorited Assets. Go to Notebook Analysis: Click to jump to the Notebook page to automatically create the corresponding Notebook task, allowing you to perform visual analytics on the asset. For more details, see Create a New Notebook. Note For Dataphin tables of the MaxCompute, Hive, AnalyticDB for PostgreSQL, or Doris type and some data source tables, you can create Notebook tasks after you request consumption permissions. For a list of supported data sources, see Operations supported by different types of assets. Go to Quick BI Analysis: Click to open the My BI Analysis panel to view the BI analysis tasks created using the current asset as a dataset. For more details, see My BI Analysis. Note For Dataphin tables of the MaxCompute, Hive, AnalyticDB for PostgreSQL, or Doris type and some data source tables, you can create Quick BI analysis tasks after you request consumption permissions. For a list of supported data sources, see Operations supported by different types of assets. Among them, when the Hive data source is CDH5.x Hive 1.1.0 version, and the MySQL data source is MySQL 5.1.43 version, it does not support creating Quick BI analysis tasks. Listing Management: Click to go to the asset editing page for the current table in Directory Management. You can modify the asset's properties and usage instructions. For more information, see Edit asset information. Feedback Quality Issues: You can use this feature to provide feedback to the current quality owner about quality issues encountered during the use of the asset (such as unstable data output, inaccurate data content), to notify relevant owners for timely rectification, thereby promoting the improvement of asset availability and health. For configuration details, see Add and Manage Issue Checklist. You need to activate the Data Quality module to use the Feedback Quality Issues feature. Subsequently, you can view the processing flow and results of the feedback issues in the issue checklist of the Quality module. View DDL Statement: If the data table is a Dataphin table, you can view its DDL statement in the tenant's compute engine. You can also select a Data Source Type and click Generate DDL Statement. The system generates a DDL statement to create a table with the same structure in the specified data source. If you select Automatically Add Escape Characters, the generated DDL statement includes the correct escape characters for the selected source type. This reduces issues such as incorrect escaping of system keywords. Some data source tables support viewing DDL statements. For more information, see Operations supported by different types of assets. Export Fields: Export the field information in the table to local, in CSV format, for other developers or business personnel to quickly analyze and use. Request Permissions: Request consumption permissions for the asset. You cannot request consumption permissions for source system tables. For more information, see Request consumption permissions. Add to Application Basket: Supports adding assets to the application basket to apply for consumption permissions collectively. Source system tables do not support applying for consumption permissions. For more details, see Apply for Consumption Permissions.
②Basic Information	Property Information: Displays the property information of the data table, including business properties, management properties, and technical properties. Business Properties: Displays the information of the subject area it belongs to. Management Properties: Displays the information of the system it belongs to. Data Source Table: It is the source system of the collection task. Dataphin Table: Displays as -. Technical Properties: Displays the asset source, the section/project space it belongs to, database type, the project it belongs to, table type, and asset import name information. Asset Source: Data Source Table: The source path is the source system > data source name > schema where the table is located. Dataphin Table: The source path is Dataphin > project space type (logical table identified as middle layer) > project name/section name (only logical tables are included under the section). Asset Import Name: Data Source Table: The name of the data source table collection task. Dataphin Table: Displays as -. Custom Properties: Displays the properties created in Data Warehouse Plan > Attribute Management that are visible in the asset directory. Among them, custom properties belong to business properties, management properties, and technical properties. Field information: Displays the ordinal number, name, data type, description/remarks, business type/associated entity (logical dimension tables and logical fact tables display only associated entities), associated standard (requires purchasing the Data Standard module), sample data (displayed only when the data sampling feature is enabled), quality score (requires purchasing the Data Quality module and enabling quality overview in asset editing), data classification (requires purchasing the data security module), and data security level (requires purchasing the data security module). Search and filter: Search for fields by name, display name, description, or remarks. You can also filter specific fields by data classification and data security level (requires activating data security). Associated Entity: When the table type is a logical dimension table or logical fact table, it displays the associated entity configured in the associated dimension on the logical table editing page under the Development > Development page. Click the View icon after the associated entity to view information for each associated entity, including role name (such as buyer, seller role name), entity name (code), description, belonging section, subject domain. You can also perform the following operations: View Details: Click to jump to Planning > Data Architecture to view detailed information under the business entity tab. View Entity Relationship Diagram: Click to open the Entity Relationship Diagram panel to view the entity relationship diagram centered on that business entity. Business type: If a modeling metric is listed, click the metric name to go to the Directory Management > Manual Listing > Technical Metrics page and view its details. Quality Score: Click the View icon after the quality score value to view the evaluation dimensions and quality score of the current field. Click View More to jump to the Quality Overview tab of the current asset to view the quality score overview. Data preview: If the data table contains sample data, the sample data is displayed by default. You can also manually trigger a query for the latest data. If no sample data exists, a data preview query is automatically triggered. You can search or filter the data by field, view single-row data details, use automatic column width rotation, and perform row-column transformations. You can also click the sorting icon next to a field to select No Sort, Ascending, or Descending. Double-click a field value to copy it. You can view sample data and preview data. Sample data: Displayed when the data sampling switch is on and the data preview switch in the configuration is also on. This feature queries sample data only for fields for which you have column-level permissions and that do not require data masking. The system stores and sorts the sample data for each field independently, but does not guarantee the existence or correctness of row records. Data preview: If you have permissions to query the table, you can use the data preview feature. The preview shows the first 50 data records for the fields for which you have SELECT permissions (including field-level and row-level permissions). To learn how to request query permissions (if the asset consumption feature is activated, see Request consumption permissions), see Request, renew, and return table permissions, Request consumption permissions. For a list of data sources that support data preview, see Supported exploration partitions and ranges for different data sources. Note For some compute sources/data sources, if the collected table is a lake table and the default Spark SQL query engine is used, you need to enable the Spark configuration for the compute source/data source where the current table is located to perform data queries. Data Exploration: If you have activated the Data Quality function, you can configure data exploration tasks for data source tables to quickly understand the data overview, evaluate the data's availability and potential threats in advance. To enable automatic exploration, you can enable the corresponding configuration in Administration > Metadata Center > Exploration and Analysis. For exploration task configuration details, see Create a New Data Exploration Task. For supported data source types, see Exploration Partitions and Exploration Ranges Supported by Different Data Sources. Usage Instructions: You need to enable usage instructions on the manually listed table asset editing page. Displays the usage instructions of the current asset, providing information reference for data viewers and users. Lineage: You need to enable lineage on the manually listed table asset editing page. Displays the lineage event chain diagram of the system, table, and field. System Lineage: Includes the system lineage relationship of the section/project/source system to which the current asset belongs. If the related table of the source system is deleted or the collection task of the related table is deleted, it is displayed as an unknown source system. For more details, see System Lineage. Table/Field Lineage: Displays the direct lineage relationship with the current asset as the central node, including assets that are not yet listed and have no viewing permissions, but cannot view asset details. For more details, see Table-Level Lineage, Field-Level Lineage. Quality Overview: Enable the quality overview on the asset editing page for the manually listed table. You must also purchase the Data Quality module. This section shows the quality score summary and rule verification details for the current data table and its fields. For more information, see Quality overview. You can view the quality overview only for data tables that support Data Quality monitoring. For a list of supported data sources, see Data Sources Supported by Dataphin. Metadata Changes: You need to enable metadata changes on both the Metadata > Metadata Change Records page and the manually listed table asset editing page to view the version change records of metadata. For explanations of metadata version generation for different data sources, see Metadata Version. Version Comparison: Supports switching to view historical version records, displaying basic information, changed fields, and all fields. For more details, see Version Comparison. Downstream Impact: Only the most recent change supports viewing downstream impact. When the change type is addition, deletion, data type, field key type, or whether the field can be null, you can view the downstream impact.
③Asset Information	Displays the Usage Statistics and Basic Information of the data table. Usage Statistics: Includes the page views and number of favorites of the table. Page Views: Displays the page views (PV) of the current data table. Each refresh increases by one, updated in real-time. Only includes page views of the asset directory details page. Number Of Favorites: Displays the number of times the current data table has been favorited by users, updated in real-time. Basic Information: Includes the initial listing time, most recent listing time, publisher, and belonging directory.
④Application Basket	You can apply for consumption permissions of assets in bulk in the application basket to improve application efficiency. For more details, see Apply for Consumption Permissions.

System lineage

Area	Description
① Search	The search box finds expanded nodes on the page based on keywords that match the names of projects, sections, or source systems. You can use the left and right arrows next to the search box or the arrow keys on your keyboard to switch between the selected nodes. By default, the system highlights the first matching node.
② Legend	Displays the layer of the current asset. Layers include the business system (the system for data source tables and custom metrics), data collection layer (source layer), data transformation layer (the system for logical tables and modeling metrics), application data service (application layer), data service, report application layer, and general layer.
③ Lineage graph display	Displays the complete data lineage graph for the current asset. You can manually expand upstream and downstream nodes. The graph displays the direct, table-level lineage for the current table and for the table that contains the current metric. This lineage is based on a system summary. Central node: Represents the system that contains the current asset. This node is labeled Current Asset Belonging System in the upper-left corner. System details: Hover over a node to view its details. The details include the system type (project, section, or metadata), name, display name, the system's administrator (project), architect (section), or operator (system), and the number of related assets. Tables within the system: Hover over a node and click the drop-down arrow on the right to perform a fuzzy search for tables by name. Click a table name to navigate to the details page for that asset and view its data lineage. Note You can view the data lineage for a table only if it is listed in the asset editor, you have view permissions for it, and its data lineage is enabled. You can view the data lineage for tables that belong to the current system and are within the lineage scope of the current node, excluding the current table itself. Data lineage is not available for deleted tables from an unknown source system. Node connection: A solid line indicates a cross-layer dependency between assets. A dashed line indicates a self-dependency, such as one table in a system depending on another table in the same system.

Table-level lineage

Area	Description
① Search and quick filter	Search: Search for expanded nodes on the current page by table name keyword. Click the left or right arrow next to the search box or use the arrow keys on your keyboard to switch between selected nodes. The system automatically highlights the first matching node. Hide invisible tables: Select this option to hide tables that you do not have permission to view. The nodes for these tables are displayed as Hidden Node. This does not affect the display of the upstream and downstream nodes. If you clear this option, only the table names are displayed. Hide unlisted tables: Select this option to hide tables that are not listed in the asset catalog. The nodes for these tables are displayed as Hidden Node. This does not affect the display of the upstream and downstream nodes. If you clear this option, only the table names are displayed.
② Legend	Displays the layer of the current asset. The layers include the business system (for data source tables and custom metrics), data collection layer (source layer), data transformation layer (middle layer, for logical tables and modeled metrics), application data service (application layer), DataService Studio, report application layer, and general layer.
③ Data lineage graph	Displays the complete data lineage graph for the current asset. You can manually expand upstream and downstream nodes. Central node: Displays the name of the current asset. The node is labeled Current Table in the top-left corner. Table details: Hover over a node to view its details. Details include the table type, name, asset source, parent catalog, asset tags, and description. The central node does not display table details. Note You can view details only for listed tables that you have permission to view. Click a table name to open the asset's details page and view its data lineage. Fields in the table: Hover over a node and click the drop-down arrow on the right to perform a fuzzy search for fields by name. Click a field name to open the asset's details page and view its data lineage. Note You can view the data lineage only for tables that are listed, that you have permission to view, and for which data lineage is enabled in the asset editor. Excluding the current table, you can view the data lineage of other tables that belong to the current system and are within the current node's lineage scope. Node connections: A solid line indicates a cross-layer dependency between assets. A dashed line indicates a self-dependency, such as when a table depends on itself.

Field-level lineage

Area	Description
① Search	You can search for expanded nodes on the page using field name keywords. To switch between selected nodes, click the left or right arrows next to the search box or use the arrow keys on your keyboard. The first matching node is selected by default.
② Legend	Shows the layer of the current asset. The layers include the following: business system (where data source tables and custom metrics are located), data collection layer (source layer), data transformation layer (middle layer, where logical tables and modeling metrics are located), application data service (application layer), DataService Studio, report application layer, and general layer.
③ Lineage graph display	Shows the complete data lineage graph. You can manually expand multiple upstream and downstream levels. The graph supports fuzzy search using field name keywords. If a circular dependency exists, you cannot expand the graph further. In this case, you must view the downstream dependencies from the starting node. Central node: Shows the current field and its table name. The node is labeled Current Field in the upper-left corner. You can use fuzzy search with field keywords to switch between lineage graphs for different fields. Field details: Hover over a node to view its metric details. The details include the metric type, name, asset source, table, statistic granularity, directory, asset tag, and description. The central node does not show metric details. Note You can view lineage relationships only for metrics that are listed, provided you have view permissions and lineage is enabled for the metric in the asset editor. You can click a metric name to go to the metric details page and view the lineage relationship. You can click the name of the table that contains the metric to go to the asset details page and view the lineage relationship. Node connection: A solid line represents a cross-layer dependency between assets. A dashed line represents a self-dependency. An example of a self-dependency is when a field in a table depends on another field in the same table, or when a field depends on itself.

Quality overview

Area	Description
①Filter	Supports filtering the quality score overview and rule verification details you want to view based on the specified object (entire table or specific field).
②Quality Score Radar Chart	Displays the quality feature radar chart, overall quality score, and verification pass rules/scoring rules of the specified object (entire table or specific field) after filtering. Six-Feature Radar Chart: Hover the mouse over the quality feature name to view the quality score of that feature. Overall Quality Score: If the object is a table, it counts all rules that have been created and run to completion at least once for the current table. If the object is a field, it counts the rules corresponding to the current field that have been created and run to completion at least once. The calculation formula is: `Quality Score=sum (weight of each rule * quality score of that rule) / sum (weight of each rule)` Verification Pass Rules: The total number of rules that the specified object (entire table or specific field) participates in quality score calculation and has passed the verification status at least once. Scoring Rules: The total number of rules that the specified object (entire table or specific field) participates in quality score calculation.
③Score List	Displays the quality feature evaluation details of the specified object (entire table or specific field) after filtering, including evaluation dimensions, quality score, verification pass rules/scoring rules, pass rate, and the number of table-level and field-level rules. Quality Score: Based on the most recent run status of rules that the specified object (entire table or specific field) participates in quality score calculation and rule classification contains related evaluation dimension rules. The calculation formula for rules of the specified evaluation dimension is: `Quality Score=sum (weight of each rule * quality score of that rule) / sum (weight of each rule)` Validation passed rules: The total number of rules that are created for the specified object (entire table or specific field) and include the corresponding dimension, participate in quality score calculation, and have a most recent validation passed status. Scoring Rules: The total number of rules that the specified object (entire table or specific field) creates, rule classification contains related dimensions, and participates in quality score calculation. Pass Rate: That is, the percentage of `Verification Pass Rules/Scoring Rules`.
④Rule Verification Details	You need to enable rule verification details on the manually listed table asset editing page. The statistical data includes the most recent 30 days of verification records executed by monitoring rules created for the current data table, which will be counted based on the rule scoring method and verification results. You can specify a date to view rule verification details, or quickly filter Abnormal Results, or filter by verification status, or search by object or rule name keywords.