Dw technical design

Skill pugyy/dw-harness/template/.claude/skills/dw-technical-design

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-technical-design

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

数仓技术设计流程，适用于 OneData 建模、表名粒度设计、分区主键设计和字段类型约束沉淀。直接调用命令：/dw-technical-design。

SKILL.md

1.2 KB, as published. Nobody here has run it

Step 2: 技术设计

执行流程

基于 OneData 规范进行建模设计
确定表名、分区、主键
明确字段类型和特殊约束

OneData 命名规范

表名格式: [层级]_[域]_[主题]_[粒度]_[周期]
例: dws_trade_order_di (汇总层_交易域_订单主题_明细_日增量)
分区字段: partition_dt string (格式 yyyyMMdd)

输出格式

## 技术设计决策

### 基本信息
- 表名: [按 OneData 规范命名]
- 层级: [ODS/DWD/DWS/ADS]
- 主键: [字段组合]
- 粒度: [数据粒度说明]
- 周期: [全量/增量]

### 字段设计
| 字段名 | 类型 | 说明 | 数据来源 |
|--------|------|------|---------|
| ...    | ...  | ...  | ...     |

### 特殊约束
- [约束 1]
- [约束 2]

### 上游依赖
| 来源表 | 关联方式 | 说明 |
|--------|---------|------|
| ...    | ...     | ...  |

规则

输出不超过 60 行
表名必须符合 OneData 命名规范
禁止修改的表必须在约束中标注
技术设计决策写入 CLAUDE.md