Table asset details
You can view details for listed assets only. This topic describes the asset details for Dataphin tables and tables from other systems.
Prerequisites
You have enabled the Intelligent R&D edition or purchased the Asset Operations - Standard Edition value-added module.
Limitations
For data source tables, you must configure a data source code to use the data preview feature. For information about how to configure data source codes, see Data source management.
For a list of data sources that support data preview and data profiling, see Operations supported for different types of collection sources.
Table asset details
In the top navigation bar of the Dataphin homepage, choose Assets > Asset Catalog.
On the table asset tab, click the name of the target asset to open the asset details page.
The asset details page for a Dataphin table is almost identical to that for a table from another system. The following figure uses a Dataphin data table as an example.
Area
Description
①Summary
Displays the table's name, type, maximum sensitivity level (requires the Data Security feature), tags, statistical granularity, and description. This area also lets you perform the following operations:
View Metadata: Click View Metadata to open the table's details page in the asset inventory.
Search Assets: Quickly search for other data tables. Select a data table to view its details page.
Statistical Granularity: This section is displayed for aggregate logical tables that contain dimension-type fields. It allows you to view the information for each statistical granularity, including name, code, description, owning business segment, and subject domain. You can also perform the following operations:
View Details: Click to navigate to the business entity tab under Plan > Data Architecture for more details.
View Entity Relationship Diagram: Click to open the Entity Relationship Diagram panel, which shows the diagram centered on this business entity.
Favorite: Click to add or remove the asset from your favorites. After you favorite an asset, you can view all your favorite assets in the Personal Data Center. For more information, see View and manage my favorite assets.
Listing Management: Click to go to the edit page for the current table asset in Catalog Management. You can modify asset properties, usage instructions, and more. For more information, see Edit asset information.
Report Quality Issue: You can use this feature to report data quality issues (such as unstable data output or inaccurate data content) to the current quality owner. This notifies the responsible personnel to correct issues promptly, improving asset availability and health. For configuration details, see Add and manage an issue list.
You must enable the data quality module to use the Report Quality Issue feature. You can then track the processing status and results of your reported issues in the issue list of the data quality module.
View DDL Statement: For a Dataphin table, you can view the corresponding 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 type. If you select Automatically Add Escape Characters, the generated DDL statement will include escape characters appropriate for the selected source type, which helps prevent issues such as incorrect escaping of system keywords. For a list of data source tables that support viewing DDL statements, see Operations supported for different types of collection sources.
Export Fields: Export the field information of the table to a local CSV file for quick analysis by other developers or business personnel.
②Basic Information
Property Information: Displays the properties of the data table, including business, management, and technical properties.
Business Properties: Displays the subject domain information.
Management Properties: Displays the owning system information.
Data Source Table: The source system of the ingestion task.
Dataphin Table: Displayed as -.
Technical Properties: Displays information about the asset source, owning business segment/workspace, database type, owning project, table type, and asset import name.
Asset Source:
Data Source Table: The source path is Source System > Data Source Name > Table Schema.
Dataphin Table: The source path is Dataphin > Workspace Type (logical tables are marked as the intermediate layer) > Project Name/Business Segment Name (business segments contain only logical tables).
Asset Import Name:
Data Source Table: The name of the ingestion task for the data source table.
Dataphin Table: Displayed as -.
Custom Properties: Displays properties that were created in Data Warehouse Planning > Property Management and are visible in the asset catalog. Custom properties are categorized under business, management, or technical properties.
Field Information: Displays the field's sequence number, name, data type, description/remarks, business type/associated entity (dimension and fact logical tables show only associated entities), associated standard (requires the Data Standard module), sample data (displayed only if the data sampling feature is enabled), quality score (requires the data quality module and the Quality Profile must be enabled in asset settings), data category (requires the Data Security module), and data level (requires the Data Security module).
Search and Filter: You can search for fields by name, display name, description, or remarks. You can also filter fields by data category or data level (requires the Data Security module).
Associated Entity: For dimension and fact logical tables, this shows the associated entity configured on the logical table's edit page under R&D > Develop. Click the View icon next to an associated entity to see its details, including role name (e.g., buyer, seller), entity name (code), description, owning business segment, and subject domain. You can also perform the following operations:
View Details: Click to navigate to the business entity tab under Plan > Data Architecture for more details.
View Entity Relationship Diagram: Click to open the Entity Relationship Diagram panel, which shows the diagram centered on this business entity.
Business Type: If a modeling metric has been listed, you can click the metric name to go to the Catalog Management > Manual Listing > Technical Metric page to view its details.
Quality Score: Click the View icon next to a quality score to view the evaluation dimensions and score for the current field. Click View More to go to the Quality Profile tab of the current asset for a quality score overview.
Data Preview: If sample data exists for the table, it is displayed by default. You can also manually trigger a query to fetch the latest data. If no sample data exists, a data preview query is triggered automatically.
You can search or filter the data by fields, view single-row details, auto-fit column widths, and pivot rows and columns. You can also click the sort icon next to a field to select No Sort, Ascending, or Descending order. Double-click a field value to copy it. You can view sample data and preview data.
Sample Data: Displayed when data sampling is enabled and the data preview switch is turned on in the configuration. It queries only the sample data for fields to which you have column-level permissions and that do not require masking. The sample data for each field is stored and displayed with independent sorting, but the existence and correctness of complete row records are not guaranteed.
Data Preview: If you have permission to query the table's data, you can use the data preview feature. The query returns results only for fields to which you have SELECT permissions (including field-level and row-level permissions). You can preview up to 50 data records. To learn how to apply for query permissions, see Apply for, renew, and revoke table permissions. For a list of data sources that support data preview, see Supported data sources and compute engines for data profiling.
Data Profiling: If you have enabled the data quality feature, you can configure data profiling tasks for data source tables to quickly understand data profiles and assess usability and potential risks. To enable automatic profiling, you can configure it in Governance > Metadata Center > Profiling and Analysis. For more information about configuring profiling tasks, see Create a data profiling task. For a list of supported data source types, see Supported data sources and compute engines for data profiling.
Usage Instructions: This must be enabled on the edit page of the manually listed table asset. It displays usage instructions for the current asset to provide references for data browsers and users.
Data Lineage: To view the data lineage graph, you must enable this feature on the asset's edit page. The graph displays the lineage for systems, tables, and fields.
System lineage: Includes the system-level data lineage of the current asset's owning business segment, project, or source system.
If a related table in the source system is deleted or its ingestion task is deleted, the source is displayed as an unknown source system. For more information, see System lineage.
Table/Field lineage: Displays the direct data lineage centered on the current asset. This view includes assets that are not yet listed or for which you do not have view permissions. You cannot view the details of these assets. For more information, see Table-level lineage and Field-level lineage.
Quality Profile: You can view the quality profile only for data tables monitored by the data quality module. For more information, see Quality Profile. For a list of supported data sources, see Supported data sources in Dataphin.
Metadata Change: To view metadata changes, you must enable this feature on both the Metadata > Metadata Change Log page and the asset's edit page. You can view the change logs for the two most recent versions. For information on how metadata versions are generated for different data sources, see Metadata versions.
Version Comparison: You can switch between historical version records to view basic information, changed fields, and all fields. For more information, see Version Comparison.
Downstream Impact: You can view the downstream impact only for the most recent change. This is available for changes such as additions, deletions, and modifications to data type, field key type, or field nullability.
③Asset Information
Displays detailed information about the data table, including Usage Statistics and Basic Information.
Usage Statistics: Includes the table's view count and favorite count.
Views: Displays the page view (PV) count for the current data table. The count increases by one each time the page is refreshed and is updated in real time. It includes only views of the asset catalog details page.
Favorites: Displays the number of times the current data table has been favorited by users. The count is updated in real time.
Basic Information: Includes initial listing time, last listing time, publisher, and owning catalog.
System lineage
Area | Description |
①Search | You can search for expanded nodes on the current page by the name of the project, business segment, or source system. Click the left/right arrows next to the search box or use the keyboard arrow keys to quickly switch between selected nodes. The system automatically focuses on the first matched node. |
②Legend | Displays the layer to which the current asset belongs, including Business System (system of data source tables and custom metrics), Data Collection Layer (ODS layer), Data Processing Layer (intermediate layer, system of logical tables/modeling metrics), Data Application Layer (application layer), Data Service, Report Application Layer, and Common Layer. |
③Lineage graph | Displays the complete data lineage graph for the current asset. You can manually expand upstream and downstream nodes. The graph is aggregated by system and includes the direct table-level lineage for both the current table and the table containing the current metric.
|
Table lineage
Area | Description |
①Search and quick filters |
|
②Legend | Displays the layer to which the current asset belongs, including Business System (system of data source tables and custom metrics), Data Collection Layer (ODS layer), Data Processing Layer (intermediate layer, system of logical tables/modeling metrics), Data Application Layer (application layer), Data Service, Report Application Layer, and Common Layer. |
③Lineage graph | Displays the complete data lineage graph for the current asset. You can manually expand upstream and downstream nodes.
|
Field lineage
Area | Description |
①Search | You can search for expanded nodes on the current page by field name. Click the left/right arrows next to the search box or use the keyboard arrow keys to quickly switch between selected nodes. The system automatically focuses on the first matched node. |
②Legend | Displays the layer to which the current asset belongs, including Business System (system of data source tables and custom metrics), Data Collection Layer (ODS layer), Data Processing Layer (intermediate layer, system of logical tables/modeling metrics), Data Application Layer (application layer), Data Service, Report Application Layer, and Common Layer. |
③Lineage graph | Displays the complete data lineage graph. You can manually expand multiple levels of upstream or downstream nodes and perform a fuzzy search by field name. Note that if a circular dependency exists, you cannot expand the node further and must trace the downstream lineage from the starting node.
|
Quality profile
Area | Description |
①Filter | You can filter the quality score overview and rule check details by a specific object (the entire table or a specific field). |
②Quality Score Radar Chart | Displays the quality property radar chart, overall quality score, and the ratio of passed rules to scored rules for the selected object (entire table or specific field).
|
③Score List | Displays the quality property evaluation details for the selected object, including evaluation dimensions, quality score, passed rules/scored rules, pass rate, and the number of table-level and field-level rules.
|
④Rule Check Details | This must be enabled on the edit page of the manually listed table asset. The statistics include check records from the last 30 days for all monitoring rules created for the data table. These records are aggregated by the rule's scoring method and check result. You can view rule check details for a specific date, quickly filter for Exceptions, filter by check status, or search by object or rule name. |