Dw etl

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

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-etl

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

数仓 ETL 开发流程，适用于生成 ODPS/MaxCompute 建表 DDL、INSERT SQL 和 SR 建表语句，并配合 hooks 自动校验 SQL 规范。直接调用命令：/dw-etl。

SKILL.md

1.6 KB, as published. Nobody here has run it

Step 3: ETL 开发

执行流程

根据技术设计生成建表 DDL
生成 Insert SQL
生成 SR 建表语句（如需）
PostToolUse hook 自动触发 SQL 规范检查

产出文件

文件名	用途
`ddl_[表名].sql`	ODPS 建表语句
`insert_[表名].sql`	Insert SQL
`ddl_sr_[表名].sql`	SR 建表语句

强制规范

INSERT 用 OVERWRITE 模式
PARTITION 子句必须包含 partition_dt
金额字段类型 DECIMAL(20,4)
禁止 SELECT *
金额字段单位继承上游（如千元），不做转换
注释三段式：业务含义 + 数据来源 + 计算逻辑

DDL 模板

CREATE TABLE IF NOT EXISTS [表名] (
    [字段名] [类型] COMMENT '[业务含义|数据来源|计算逻辑]',
    ...
    partition_dt STRING COMMENT '分区日期|系统生成|yyyyMMdd格式'
)
PARTITIONED BY (partition_dt STRING)
COMMENT '[表注释]'
LIFECYCLE [天数];

Insert 模板

INSERT OVERWRITE TABLE [表名] PARTITION (partition_dt = '[日期]')
SELECT
    [字段列表]
FROM [来源表]
WHERE partition_dt = '[日期]'
[AND 其他条件];

自动护栏

写入 .sql 文件后，PostToolUse hook 自动检查：

发现 SELECT * → exit 2 阻断
缺少 PARTITION → exit 2 阻断
金额字段用 DOUBLE → exit 2 阻断
Claude 收到 stderr 错误信息后自动修正