Skip to content

pugyy/dw-harness / plugins/dw-harness/skills/dw-sr

Step 6/8 StarRocks 导入:按契约与 MaxCompute 表结构生成 SR 建表语句、 同步配置与风险分析。适用于数据需要从 MaxCompute 同步到 SR 时。

Step 6: SR 导入

执行流程

  1. 从契约/DDL 取字段与类型,生成 ddl_sr_[表名].sql
  2. 风险矩阵按高→低排序输出(≤20 行)
  3. SR 文件自动按 starrocks 方言校验(*_sr_* 路径映射)

风险矩阵

风险项检查内容等级
类型精度DECIMAL/DOUBLE → DECIMAL(p,s) 按契约高
Key 模型PRIMARY/DUPLICATE/UNIQUE 合理性高
金额单位与 MaxCompute 侧契约单位是否一致高
分区数量与源表匹配中
分桶DISTRIBUTED BY HASH 分桶数中
DATETIME存储方式(避免全表扫描)中
字符集编码兼容低

规则

  • SR 的 INSERT 可省略分区(引擎合法),本项目默认告警不阻断
  • 单位换算在契约 unit 声明,不在 SQL 里做隐式转换
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