Skip to content

DataWithBaraa/claude-code-data-engineering-skills / skills/reconcile

reconcile

Unverified

Use when two numbers that should agree do not, a report against its source, a rollup against its detail, two systems for the same table, to find where they diverge and why.

Reconcile

The job: two numbers that should match, the places where they stop matching, and the reasons. It reads, it changes no number.

Input: the two sides, the report, query or table of each, and the number each one gives.

Steps

  1. Name the two sides: the query, the table and the filter of each, and the number each one gives.
  2. Make both sides comparable: the same grain, the same period, the same filters, the same currency and unit, the same time zone.
  3. Compare the totals, then split by the dimensions until a difference sits in one slice: a day, a source, a status, a key.
  4. In that slice, compare row by row: the rows only on one side, and the rows on both sides with different values.
  5. Name the cause: a filter, a join that drops or doubles rows, a late delivery, a type conversion, a rounding, a time zone.
  6. After each cause, show what is left of the difference, and go on until it is zero or inside the agreed tolerance.
  7. Say which side is right, with the proof from the source.
  8. Give the result as one web page.

Output

One HTML file: the two numbers on top, the difference, the drill-down from the total to the slices, the rows behind each cause, and what is left after each cause.

Reads

  • both sides, the data contracts, the pipeline SQL, the query logs

Writes

  • the web page only

Never

  • Never changes a number on either side.
  • Never calls it a rounding difference without showing the rows.
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 195kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 192kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 192kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 192kUpdated Claude CodeCodexVerifiedInstall