Hi Sachin,

HVR doesn’t currently offer a built-in alert for when the row-count difference between a source and target table exceeds a threshold. However, a straightforward workaround is available using the Compare functionality.

You can configure a Compare job (Row Counts Only) to capture discrepancies in row counts. These results are recorded in the Compare Event and can be accessed in the UI (Events → Results pane) or via the REST API.

Here’s how you can set this up:

1. Schedule a Compare job (Row Counts Only) to run at your desired interval.

2. Retrieve the results using one of the following:

3. • REST API: POST /api/…/compare followed by …/compare/table_results_ids

   • Command line: hvrcompare -Rjson

   • UI Export: Use the View Results export function

4. Use an external monitor (e.g., Cron + Python, Prometheus, or PagerDuty) to evaluate
   abs(row_source - row_target) > <your_threshold>
   And trigger alerts when the threshold is breached.

We are not planning to build this in HVR.