ARS.FLOW
← Back to ETL Reconciliation Check

ETL Reconciliation Check Documentation

Runtime-generated docs from the validated registry. Use this page as the in-app skill reference while external source repositories are still being finalized.

Workflow summary

Compares source and target ETL summaries with deterministic checks to catch data-loss and transformation drift before release.

Version
0.1.0
Updated
Apr 22, 2026
Reliability
high
Risk
high

Verification and assets

  • reconciliation checks
  • integration tests

Included files

  • scripts/reconcile_summaries.py (script) - Compares source and target summary JSON metrics.
  • references/reconciliation-policy.md (reference) - Policy thresholds and blocking criteria for reconciliation checks.
  • references/window-alignment-guide.md (reference) - Guide to prevent false mismatches from window skew.
  • references/mismatch-triage-playbook.md (reference) - Step-by-step triage flow for reconciliation mismatches.

Inputs

  • source_summary (json) - Source dataset counts, duplicates, and checksums.
  • target_summary (json) - Target dataset counts, duplicates, and checksums.

Outputs

  • reconciliation_report (markdown) - Deterministic report of count and checksum mismatches.

Source metadata

Declared source URL in registry:

https://github.com/SHREYAS290601/ars.flow-skills/tree/main/skills/etl-reconciliation-check