Dataphin:View table asset details

Prerequisites

You have purchased the Asset Operations value-added service, and the Asset Operations module is enabled for the current tenant.

Limitations

• When the data source type is PolarDB-X (formerly DRDS), SAP HANA, IBM DB2, or OceanBase (in MySQL or Oracle tenant mode), you cannot apply for consumption permissions for data source tables or their custom metrics.

• For data source tables, configure a data source code to use data preview. Data source management.

• For supported data sources for data preview and data profiling, see Operations supported for different types of collection sources.

Table asset details

1. In the top navigation bar of the Dataphin homepage, choose Assets > Asset Catalog.

2. 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 nearly identical to that for an external system table. The following example uses a Dataphin data table.

   

   Area	Description
   ①Summary	Shows the table name, type, maximum sensitivity level (requires Data Security), tags, statistical granularity, and description. You can also: View Metadata: Opens the table's details page in the asset inventory. Search Assets: Search for and navigate to other data tables. Statistical Granularity: Displayed for aggregate logical tables with dimension-type fields. Shows the name, code, description, owning business segment, and subject domain for each granularity. You can also: View Details: Navigates to the business entity tab under Plan > Data Architecture. View Entity Relationship Diagram: Opens the Entity Relationship Diagram panel centered on this business entity. Favorite: Add or remove the asset from your favorites. Favorited assets appear in the Personal Data Center. For more information, see View and manage my favorite assets. Analyze in Notebook: Opens the Notebook page and creates a Notebook task for visual analysis. Create a Notebook. Note After obtaining consumption permissions, you can create Notebook tasks for Dataphin tables of the MaxCompute, Hive, AnalyticDB for PostgreSQL, Doris, and StarRocks types, and for some data source tables. Operations supported for different types of assets. Analyze in Quick BI: Opens the My BI Analysis panel, showing BI analysis tasks that use the current asset as a dataset. My BI Analysis. Note After obtaining consumption permissions, you can create Quick BI analysis tasks for Dataphin tables of the MaxCompute, Hive, AnalyticDB for PostgreSQL, Doris, and StarRocks types, and for some data source tables. Operations supported for different types of assets. You cannot create Quick BI analysis tasks if your Hive data source is CDH 5.x Hive 1.1.0 or your MySQL data source is MySQL 5.1.43. Listing Management: Opens the edit page for the current table asset in Catalog Management, where you can modify asset properties and usage instructions. Edit asset information. Report Quality Issue: Report data quality issues (such as unstable output or inaccurate content) to the quality owner for prompt correction. Add and manage an issue list. Requires the data quality module. Track reported issues in the data quality module's issue list. View DDL Statement: View the DDL statement for a Dataphin table in the tenant's compute engine. Select a Data Source Type and click Generate DDL Statement to create a DDL with the same table structure. Select Automatically Add Escape Characters to include escape characters for system keywords. Operations supported for different types of assets. Export Fields: Export table field information to a CSV file for offline analysis. Apply for Permissions: Enable data consumption on the asset's edit page first. Apply for consumption permissions. Add to Application Basket: Enable data consumption on the asset's edit page first. Apply for consumption permissions.
   ②Basic Information	Property Information: Shows business, management, and technical properties of the data table. Business Properties: Shows subject domain information. Management Properties: Shows owning system information. Data Source Table: The source system of the ingestion task. Dataphin Table: Displayed as -. Technical Properties: Shows 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: Properties created in Data Warehouse Planning > Property Management and visible in the asset catalog, categorized under business, management, or technical properties. Field Information: Shows each 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 Data Standard), sample data (displayed only if data sampling is enabled), quality score (requires data quality with Quality Profile enabled), data category (requires Data Security), and data level (requires Data Security). Search and Filter: Search fields by name, display name, description, or remarks. Filter by data category or data level (requires Data Security). Associated Entity: For dimension and fact logical tables, shows the associated entity configured on the logical table's edit page under R&D > Develop. Click the View icon to see details including role name (e.g., buyer, seller), entity name (code), description, owning business segment, and subject domain. You can also: View Details: Navigates to the business entity tab under Plan > Data Architecture. View Entity Relationship Diagram: Opens the Entity Relationship Diagram panel centered on this business entity. Business Type: If a modeling metric is listed, click the metric name to go to Catalog Management > Manual Listing > Technical Metric to view its details. Quality Score: Click the View icon to see evaluation dimensions and score for the field. Click View More to go to the Quality Profile tab for a quality score overview. Data Preview: If sample data exists, it displays by default. You can also manually trigger a query for the latest data. If no sample data exists, a data preview query runs automatically. Search or filter data by fields, view single-row details, auto-fit column widths, and pivot rows and columns. Click the sort icon next to a field to select No Sort, Ascending, or Descending. Double-click a field value to copy it. Sample Data: Displayed when data sampling is enabled and data preview is turned on. Queries only sample data for fields to which you have column-level permissions and that do not require masking. Sample data for each field is stored with independent sorting, but complete row records are not guaranteed. Data Preview: If you have query permissions for the table, use data preview. Results include only fields to which you have SELECT permissions (including field-level and row-level). Up to 50 records can be previewed. To learn how to apply for query permissions (if asset consumption is enabled, see Apply for consumption permissions), see Apply for, renew, and revoke table permissions and Apply for consumption permissions. For supported data sources, see Supported data sources and ranges for data profiling. Note For some compute engines or data sources, if the collected table is a lake table that uses the Spark SQL query engine by default, you must enable Spark configuration for the table's compute engine or data source before you can query its data. Data Profiling: If data quality is enabled, configure data profiling tasks for data source tables to understand data profiles and assess usability. To enable automatic profiling, configure it in Governance > Metadata Center > Profiling and Analysis. Create a data profiling task. For supported data source types, see Supported data sources and ranges for data profiling. Usage Instructions: Must be enabled on the edit page of the manually listed table asset. Shows usage instructions for the current asset as a reference for data consumers. Data Lineage: Enable this on the asset's edit page to view the data lineage graph for systems, tables, and fields. System lineage: Shows 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: Shows the direct data lineage centered on the current asset. Includes assets that are not yet listed or for which you lack view permissions. You cannot view details of these assets. Table-level lineage and Field-level lineage. Quality Profile: View quality profiles only for tables monitored by the data quality module. Quality Profile. For supported data sources, see Data sources supported by Dataphin. Metadata Change: Enable this on both the Metadata > Metadata Change Log page and the asset's edit page. View change logs for the two most recent versions. For how metadata versions are generated, see Metadata versions. Version Comparison: Switch between historical versions to view basic information, changed fields, and all fields. Version Comparison. Downstream Impact: View downstream impact only for the most recent change, including additions, deletions, and modifications to data type, field key type, or field nullability.
   ③Asset Information	Shows detailed information about the data table, including Usage Statistics and Basic Information. Usage Statistics: Shows the table's view count and favorite count. Views: Page view (PV) count for the data table. Increases by one on each page refresh and updates in real time. Counts only views of the asset catalog details page. Favorites: Number of times users have favorited the data table. Updates in real time. Basic Information: Shows initial listing time, last listing time, publisher, and owning catalog.
   ④Application Basket	Add multiple assets to the application basket and apply for consumption permissions in a single batch. Apply for consumption permissions.

System lineage

Table lineage

Field lineage

Quality profile