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.
