pugyy/dw-harness / plugins/dw-harness/skills/dw-backfill
dw-backfill
Verified历史回填预演:目标环境、分区范围、幂等策略、检查点与扫描估算, 预演阶段只读不落盘。适用于需要重刷历史分区时。
dw-backfill:回填预演(只读)
dw plan backfill --table db_a.dws_trade_order_di \
--start 20260101 --end 20261115 --sql insert_dws_trade_order_di.sql --env prod
预演产出
- 目标环境 / 表 / 分区范围
- 幂等策略:按分区
INSERT OVERWRITE,重跑即覆盖,禁与 INSERT INTO 混用 - 检查点:
.claude/dw/backfill/[表].json(pending/running/done/failed 逐分区) - 扫描估算:MaxCompute
COST SQL(预演不执行,估不出显示"未知") - 恢复方案:失败分区可幂等重跑;错值回填用修正 SQL 重刷同范围
纪律
- 生产回填:预演 → 人工确认 → 走正式调度执行;guard 对 prod 覆盖类操作默认 ask/deny
- 回填期间 DQC 临时降级要在评审中显式记录
- 完成后按分区抽 reconcile 证据,
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: 196k | 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: 196k | 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: 196k | Updated | Claude CodeCodex | Verified | Install |