View Comparison Details

To view the details of your comparisons, click on the Comparisons tab in the left-side navigator and select the comparison you want to explore.

Once you select a comparison, the Overview tab provides a high-level summary of the comparison, including Overview, Schema, Primary Keys, Value

Overview

Comparison Summary

On the left side of the comparison overview, you can find a summary of the comparison:

Field	Description
Run ID	Unique identifier for this comparison run.
Status	Indicates the comparison has successfully completed.
Diff Pks	Shows the percentage of differences found in primary key values.
Diff Rows	Shows the values of differences found in rows between datasets.
Created At	Timestamp of when the comparison was initiated.
Duration	Time taken to complete the comparison.
Origin	Indicates the source of execution.

Comparison Overview

Rows Comparison: Shows the total number of rows in the Source and Target datasets and the count of differing rows.
Schema Comparison: Lists the number of columns, identical columns, unmatched data types, and any added or removed columns.
Primary Keys: Displays the count of exclusive primary keys in both datasets.
Values Comparison: Indicates the number of columns with differing values and any columns that were not compared.

For further analysis, you can navigate to the Schema, Primary Keys, or Values tabs for a more detailed breakdown of differences.

Schema

In the schema tab, you will find the following details about your comparison:

Source and Target dataset names and types, along with their status.
Mapped columns, if any were added.
Schema status, indicating whether the schemas are identical or have differences.
Values status, showing whether the column values match or differ. If differences exist, it includes the percentage difference. Highlights If there are any values exclusive to either the source or target dataset, you will see the status indicating exclusivity to that column.
You can filter the schema comparison by schema status and values status by clicking on the respective filter options.

This will help ensure that the structure of your datasets aligns correctly, facilitating data integrity and quality.

Primary Keys

This tab provides detailed insights into primary key differences and exclusivity.

Field	Description
Duplicate PKs in Source	Lists primary keys that appear more than once in the source dataset.
Duplicate PKs in Target	Lists primary keys that appear more than once in the target dataset.
Rows Exclusive to Source	Displays rows that exist only in the source dataset.
Rows Exclusive to Target	Displays rows that exist only in the target dataset.

You can also download this information in Excel format for further analysis.

This helps identify potential data inconsistencies and ensures primary keys remain unique across datasets.

Customize Table View

You can adjust the table view to better suit your needs:

Set Filter: Click on the filter icon to open the filter panel. Use the search bar to find specific columns and check or uncheck boxes to display or hide columns.
Resizing Columns: Adjust column width by dragging the column headers to resize them as needed.

Values

The Values tab in the comparison tool highlights differences between the source and target datasets. It shows mismatched values, percentage differences, and a breakdown of inconsistencies in a clear format.

At the top, you’ll see an overview of how many values differ and the percentage of differences for each column. There’s also a Semantic Similarity toggle, which helps identify values that are similar but not exactly the same (useful for detecting small variations).

Table View

In the table header, you can see the configured column mappings along with a progress bar and percentage to visualize the identicality of two columns.You can also see how many rows are different.

In the table, values from the source and target datasets are compared side by side. A highlighter visually indicates their level of similarity:

Red represents significant differences, meaning the values in the source and target datasets do not match.
Yellow indicates partial similarity, where the values are not identical but share some common elements.
No color indicates that the values are identical across both datasets.

Hovering over a highlighted value reveals its similarity score, which helps you understand how closely the data points align.

You can download the data differences in Excel format from the top right corner for further analysis.

Customize Table View

You can adjust the table view to better suit your needs:

Set Filter: Click on the filter icon to open the filter panel. Use the search bar to find specific columns and check or uncheck boxes to display or hide columns.
Resizing Columns: Adjust column width by dragging the column headers to resize them as needed.

Manage Comparison

On the top right corner of each tab, the Actions menu provides options to manage your schema comparison. You can:

Action	Description
Rerun	Runs the comparison again to check for any updates in the source and target datasets.
Clone	Creates a duplicate of the current comparison. This helps in reusing configurations without altering the original.
Info	Displays primary key details for comparisons across the same or different data sources, including source and target dataset information, filters, semantic similarity, and the column mapping configured by the user.
Delete	Permanently removes the comparison. This action cannot be undone.