Data Validation

Easily compare records across two tables and report on the differences, in one command

How To Validate Tables Contain The Same Data

Use the hp diff command to compare records across source and target tables.

Differences are output in JSON format separated by new lines, where the source is considered the new dataset and the target is the old (reference) data.

  • Supply the primary key fields to sort and join the two datasets for comparison
  • Optionally choose the number of differences allowed before exiting