Skip to content

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 收口
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: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 196kUpdated 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: 196kUpdated Claude CodeCodexVerifiedInstall