Dw dqc

Skill pugyy/dw-harness/template/.claude/skills/dw-dqc

A Claude Code engineering template for reliable data warehouse AI development./面向数仓 AI 开发的 Claude Code 工程化模板：hooks、skills、subagents 与八步标准流程。

Install

npx -y skills add pugyy/dw-harness --skill dw-dqc

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

3 stars3 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

数仓 SLA/DQC 规则配置流程，适用于生成完整性、准确性、一致性和时效性质量规则 JSON。直接调用命令：/dw-dqc。

SKILL.md

1.7 KB, as published. Nobody here has run it

Step 8: SLA/DQC

执行流程

基于表结构和业务规则生成 9 类 DQC 规则
配置 SLA 产出时间
输出 DQC 配置 JSON

9 类 DQC 规则

完整性规则 (3 类)

主键非空: 主键字段不允许 NULL
分区数据量: 分区行数在合理范围内（波动 ≤ 30%）
必填字段完整: 核心业务字段不允许 NULL

准确性规则 (2 类)

金额字段容差: 核心金额字段与上游差异 ≤ 0.01%
数值范围检查: 字段值在业务合理范围内

一致性规则 (2 类)

联动逻辑: 如 is_perform 与 perform_flag 的对应关系
上下游一致性: 汇总值与明细汇总一致

时效性规则 (2 类)

产出时间 SLA: 数据产出时间 ≤ 次日 8:00
数据新鲜度: 最大分区日期与当前日期差值 ≤ 1 天

输出格式

{
  "table_name": "[表名]",
  "sla": "08:00",
  "rules": [
    {
      "type": "completeness",
      "name": "主键非空",
      "field": "[字段名]",
      "condition": "IS NOT NULL",
      "severity": "critical"
    },
    {
      "type": "accuracy",
      "name": "金额容差",
      "field": "[金额字段]",
      "threshold": "0.01%",
      "compare_with": "[上游表]",
      "severity": "critical"
    },
    {
      "type": "timeliness",
      "name": "产出时间",
      "sla": "08:00",
      "severity": "warning"
    }
  ]
}