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	No differences found in primary keys.
Diff Rows	No differences found in rows.
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 exclusive and duplicate primary keys across 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.
Status of the schema comparison, indicating whether they are identical or different ( along with percentage values).
If there are any values exclusive to either the source or target dataset, you will see the status indicating exclusivity to that column.

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

Manage Schema

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

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

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.

Manage Primary Keys

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

Action	Description
Info	Displays primary key details for comparisons across the same or different data sources, including source and target dataset information, primary keys, semantic similarity, and the column mapping configured by the user.
Delete	Permanently removes the primary key comparison from the platform. This action cannot be undone.

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.