View profiling details at the dataset level

Profiling details can be accessed at the dataset level, allowing you to review both dataset profile metrics and column-level metrics directly from the dataset tab in the catalog. This functionality offers a comprehensive overview of the dataset, making it ideal for those seeking to thoroughly understand its structure, usage, and quality.

To access a detailed view of the profiling metrics for the associated dataset:

1. From the main navigation menu, click Catalog and navigate to the Datasets tab.
2. Click on the required dataset name to open the details page.
3. Select the Profile tab to view the profiling details. The profiling tab displays the following details:
   • Table Summary: This section displays the following details
     • Effective date: It displays the latest timestamp of the profile run.
     • Total row count: Total number of rows considered for profiling.
     • Sample row count: Number of rows present in the generated sample
     • You can view the previous profile runs by clicking the arrows and at any point, you can switch back to view the details of the Latest profile run.
   • Asset details: The asset details table displays the following details of the fields associated with profiling
     • Field: Name of the field associated with the profiling details
     • Data type: The data type in the field.
     • Popularity: Shows the number of times the field is used in the database queries. This is the count of both manual queries run on your database instance and queries run during Profile/Observer runs.
     • Null count: Displays the number of null values in every row of the table.
     • Blank count: Displays the number of blank values in every row of the table.
     • Distinct values: Display the count of all the records present in your data source irrespective of those being unique or non-unique records.
     • Semantic type:^{* Limited Availability} Displays the detected semantic type. It will not be displayed if the semantic type is not detected in the data. Click the refresh icon next to the corresponding semantic type to re-run the semantic type detection and identify the semantic type. If you run semantic type detection again, you'll see the timestamp of the latest execution by hovering over the semantic type. A semantic type job will also appear in the assessments tab under Quality jobs to show its progress.
     • Minimum value: Represents the lowest value for numerical data or the earliest date in a dataset.
     • Maximum value: Refers to the greatest numerical value or the latest date present within a given dataset.
     • Minimum length: Minimum length is the smallest length of the text in the textual dataset. For example, the set CITY={Sao Paulo, Mexico, Tokyo, Shanghai, Cairo, Mumbai} contains the lowest value for "Cairo" and "Tokyo". The minimum length of the set CITY is 5.
     • Maximum length: Maximum Length is the largest length of the text in the textual dataset. For example, the set CITY={Sao Paulo, Mexico, Tokyo, Shanghai, Cairo, Mumbai} contains the largest value for "Sao Paulo". The maximum length of the set CITY is 9.

       The sort functionality enables you to arrange the data within table columns according to your preferred order, while the search bar provides the capability to locate specific parameters displayed in the table.

4. Clicking on a field name displays the profiling details associated with the field in a side panel.