pugyy/dw-harness / plugins/dw-harness/skills/dw-data-comparison
dw-data-comparison
VerifiedStep 5/8 数据比对:新旧表/上下游键级对账,产出可复跑的对账证据, 只回收差异摘要。适用于自测通过后与基线数据核对。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 1.1 KB |
SKILL.md
View on GitHub---
name: dw-data-comparison
description: >
Step 5/8 数据比对:新旧表/上下游键级对账,产出可复跑的对账证据,
只回收差异摘要。适用于自测通过后与基线数据核对。
argument-hint: "[表名] [分区日期] [基线表]"
context: fork
agent: dw-harness:data-comparator
allowed-tools: Read, Grep, Glob, Bash(dw reconcile:*), Bash(dw check:*)
---
# Step 5: 数据比对(键级对账)
## 执行流程
1. 固定比较双方:表/分区/业务键/度量列/容差(单位换算按契约)
2. 跑确定性对账并存证据:
```bash
dw reconcile --spec reconcile_[表].json --save-evidence
```
3. 预检(空键/重复键/缺失分区)失败先修数,再做键级比较
4. 只把差异摘要交回主对话
## 对账 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` 复核)
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 198k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| 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: 194k | Updated | Claude CodeCodex | Verified | Install |