# Source: https://docs.datafold.com/data-diff/in-database-diffing/results.md

# Source: https://docs.datafold.com/data-diff/cross-database-diffing/results.md

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datafold.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Results

> Once your data diff is complete, Datafold provides a concise, high-level summary of the detected changes in the Overview tab.

## Overview

<Frame>
  <img src="https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=dfb2b6c8d95632782f33082cd32fef46" data-og-width="3032" width="3032" data-og-height="1716" height="1716" data-path="images/overview.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?w=280&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=f781b8b739c36996213743bfdc4672f3 280w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?w=560&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=13405f054e2b826a3674ef43e4bfab2f 560w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?w=840&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=12d421fac1618936be457938eaa78a7c 840w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?w=1100&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=9fcea4c4a22bc1f43f7dd73b5b7604fe 1100w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?w=1650&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=95f372d97128840e8f445ca97b510946 1650w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/overview.png?w=2500&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=5c15b56749bd776c57fcd56a7efe7198 2500w" />
</Frame>

The top-level menu displays the diff status, job ID, creation and completed times, runtime, and data connection.

## Columns

<Frame>
  <img src="https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=ac6c1544f226b273327ecc43cd48d73f" data-og-width="2984" width="2984" data-og-height="1692" height="1692" data-path="images/columns.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?w=280&fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=a9460414bdee320a50efcb48c76b6691 280w, https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?w=560&fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=e1a2ba2a72f07642c021b6a70abd5d36 560w, https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?w=840&fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=1b7ad4841814550a14c18242a8556ec0 840w, https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?w=1100&fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=ed71f0451159487de75976ff9c8a389d 1100w, https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?w=1650&fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=a6174dcc4937b49a86cd45331320ea9a 1650w, https://mintcdn.com/datafold/hQ4DukKOuaj6vjhH/images/columns.png?w=2500&fit=max&auto=format&n=hQ4DukKOuaj6vjhH&q=85&s=339e7bc4dc6ff2531202512abcf625d7 2500w" />
</Frame>

The Columns tab displays a table with detailed column and type mappings from the two datasets being diffed, with status indicators for each column comparison (e.g., identical, percentage of values different). This provides a quick way to identify data inconsistencies and prioritize updates.

## Primary keys

<Frame>
  <img src="https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=c37832ea5462bba8e883165c1b4f3e71" data-og-width="2986" width="2986" data-og-height="1718" height="1718" data-path="images/primarykeys.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?w=280&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=cd2a6b78def0d742873821dca35c6827 280w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?w=560&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=875e5e8e3e9876dc050c8e8dabd60158 560w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?w=840&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=5d767e5850460b8c1d1153ac90701782 840w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?w=1100&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=4fb58adce588950286daf490d3e3eb18 1100w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?w=1650&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=50d3ebdaa886dea515022f6eff83c485 1650w, https://mintcdn.com/datafold/9DgdnO4sVNte36u-/images/primarykeys.png?w=2500&fit=max&auto=format&n=9DgdnO4sVNte36u-&q=85&s=cd23ad6685d95488bc2d210a0895d8cc 2500w" />
</Frame>

This tab highlights rows that are unique to the Target dataset in a data diff ("Rows exclusive to Target"). As this identifies rows that exist only in the Target dataset and not in the Source dataset based on the primary key, it flags potential data discrepancies.

The Clone **diffs and materialize results** button allows you to rerun existing data diffs with results materialized in the warehouse, as well as any other desired modifications.

## Values

<Frame>
  <img src="https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=eeefef58cfe6776d6d768b4062b03a59" data-og-width="3038" width="3038" data-og-height="1720" height="1720" data-path="images/values.png" data-optimize="true" data-opv="3" srcset="https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?w=280&fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=a234902e17b71d481d5e9ec7300d9f92 280w, https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?w=560&fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=cd4ed9f61cc6bc53f1392f6a770cd1f9 560w, https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?w=840&fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=4a907912eb3a9cf8bd39683f44fa37e6 840w, https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?w=1100&fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=83f8e29e4f0b869ac75572940a35b6c7 1100w, https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?w=1650&fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=2a46e3fd9f201d65775a6409984fac40 1650w, https://mintcdn.com/datafold/4ZNRDufNo9R1p08Q/images/values.png?w=2500&fit=max&auto=format&n=4ZNRDufNo9R1p08Q&q=85&s=df76fcf99f3b2c8433c2e3598b8bb1e4 2500w" />
</Frame>

This tab displays rows where at least one column value differs between the datasets being compared. It is useful for quickly assessing the extent of discrepancies between the two datasets.

The **Show filters** button enables the following features:

* Highlight characters: highlight value differences between tables
* % of difference: filters and displays columns based on the specified percentage range of value differences