Skip to content

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

dw-data-comparison

Verified

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

FileKindSize
SKILL.mdskill md1.1 KB
---
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` 复核)
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: 198kUpdated 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