transfer-reconciliation

What problem does it solve?

After completing a data transfer or migration, manually verifying that all rows were moved correctly is time-consuming and prone to error, especially for derived queries or large datasets where re-scanning the source system is costly or impossible.

Core Features & Use Cases

• Row Count Parity Check: Automatically compares tool-reported source and transferred row counts without re-querying the source system, eliminating unnecessary load on production data sources.
• Target-Side Validation: Runs a lightweight COUNT(*) query on the target table to confirm the actual row count matches the transferred count, catching any issues with the transfer process itself.
• Advisory Target Sample: Optionally reads a small sample of rows from the target table to confirm it is fully queryable and accessible after the transfer.
• Use Case: For example, after transferring aggregated customer sales data from a production PostgreSQL database to a ClickHouse analytics warehouse, use this skill to automatically confirm row counts match and the target table is accessible without manual querying.

Quick Start

Use the transfer-reconciliation skill to validate row counts and target accessibility for your most recent data transfer run.