Data Profiling

Back Next

Compare profile runs

You can compare the results for two profile runs to analyze and compare the content and statistics. After you select the profile runs to compare, the comparison results appear on the Compare Runs
tab.

The later profile run results are compared to the previous profile run results. If a column was added in the later run, the column name appears with the term Added
. If a column was removed in the later run, the column name appears with the term Removed
.

When you change the source object after multiple runs,

Data Profiling

retains the profile results for all the profile runs in the profiling warehouse. You can compare the profile results for the previous and current source object. The columns of the previous source object appears as Removed
and the columns of the current source object appears Added
on the

Compare Runs

tab.

Example

You are a data steward. You create a profile on the Customer table. You need to identify the customers who were added to or deleted from a subscription in a month.

To accomplish the task, perform the following tasks:

Run the profile on the Customer table on a monthly basis.

Compare the latest profile results with the previous one or as required.

Analyze the compare run results.

The

Compare Runs

tab displays a tree previewer to help you navigate to the profile runs of the nested columns for profiles that you create with Avro or Parquet source objects.

The following image displays a sample

Compare Runs

tab with a tree previewer: