Skip to content

pugyy/dw-harness / plugins/dw-harness/skills/dw-data-comparison

dw-data-comparison

Verified

Step 5/8 数据比对:新旧表/上下游键级对账,产出可复跑的对账证据, 只回收差异摘要。适用于自测通过后与基线数据核对。

Step 5: 数据比对(键级对账)

执行流程

  1. 固定比较双方:表/分区/业务键/度量列/容差(单位换算按契约)
  2. 跑确定性对账并存证据:
dw reconcile --spec reconcile_[表].json --save-evidence
  1. 预检(空键/重复键/缺失分区)失败先修数,再做键级比较
  2. 只把差异摘要交回主对话

对账 spec 要点

  • keys:业务键(契约 business_keys)
  • metrics:列 + abs_tol + rel_tol + 双方 unit(按契约换算到最小单位)
  • 零基线:一侧为 0 时任何非零差都算 FAIL;NULL==NULL 视为相等,NULL vs 值单列

交付物

  • reconcile_[表].json(spec,进仓库)
  • .claude/dw/evidence/reconcile-[表].json(证据,dw check 复核)
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: 197kUpdated 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: 194kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 194kUpdated 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: 194kUpdated Claude CodeCodexVerifiedInstall