huawei-cloud-dws-migration-teradata-to-dws SKILL.md skillA
huawei-cloud-dws-migration-teradata-to-dws from huaweicloud/huaweicloud-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add huaweicloud/huaweicloud-skills/huawei-cloud-dws-migration-teradata-to-dws@git:20260929.dbb1d02Pins git:20260929.dbb1d02 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- huaweicloud/huaweicloud-skills
- Path
skills/bigdata/dws/huawei-cloud-dws-migration-teradata-to-dws/SKILL.md- Versions recorded
- 1
- Latest version
- git:20260929.dbb1d02, committed Sep 29, 2026
- Size
- 24,462 bytes
- Repository stars
- 59
- License
- MIT
Teradata 到华为云 DWS（数据仓库服务）的全流程迁移 skill。严格遵循源端 Teradata 只读、 Teradata→DWS 数据类型映射、先迁移表结构(DDL)后迁移数据(DML)、OBS 临时目录导出、 COPY 命令批量导入等核心规则。包含迁移前预检(pre_migration_check)、表结构迁移(migrate_schema)、 PPI 分区表转换(ppi_converter)、视图/宏/存储过程迁移(migrate_views_procs)、 数据迁移(migrate_data)与迁移验证(validate_migration)等完整工具链。 Applicable when users need to migrate Teradata databases to Huawei Cloud DWS, convert Teradata schema/data types to DWS, or move TD workloads to GaussDB DWS. 触发词："Teradata迁移"、"迁移到DWS"、…
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# Teradata to DWS Migration Skill
## 概述
本 skill 用于将 Teradata 数据库迁移到华为云 DWS（数据仓库服务）。迁移过程严格遵循以下核心规则：
1. **禁止在源端 Teradata 进行任何写操作** — 所有对源端的访问均为只读
2. **遵循 Teradata 到 DWS 的数据类型映射规则** — 参考 https://support.huaweicloud.com/migration-dws/dws_15_0131.html
3. **迁移分为两大步骤** — 先迁移表结构（DDL），后迁移表数据（DML）
4. **重复表需用户确认** — 发现 DWS 中已存在的表时，列出并询问用户确认后才删除重建
5. **OBS 临时目录** — 数据导出到 OBS 而非本地磁盘，避免磁盘容量问题
6. **COPY 命令批量导入** — 使用 COPY 命令替代逐行 INSERT，性能提升 10-100 倍，支持 TB 级数据
## 迁移流程
```
Step 0 迁移前预检 pre_migration_check.py 网络/源端/目标端/业务影响/时间预估（全部只读）
↓
Step 1 表结构 DDL migrate_schema.py 只读提取 DDL → 数据类型映射 → PPI 分区转换(ppi_converter)
→ 生成 DWS DDL → 重复表确认 → 建表
↓
Step 2 表数据 DML migrate_data.py CSV/OBS 临时目录导出 → 实时进度 → COPY/OBS 外表导入 → 校验
↓
Step 2.5 视图/宏/过程 migrate_views_procs.py 提取(SHOW VIEW/MACRO/PROCEDURE) → SQL 语法转换 → DWS 重建
↓
Step 3 数据校验 validate_migration.py 表数/行数/列/聚合/抽样/TIMESTAMP 精确值比对
↓
Step 3.5 功能性校验 validate_functional.py 宏/存储过程/视图调用与结果比对
```
## 使用前提
### 环境要求
- Python 3.8+
- Teradata ODBC 驱动 或 teradatasql Python 包
- DWS gsql 客户端 或 psycopg2 Python 包
- （可选）DSC 工具 — 用于 SQL 脚本迁移，需 JDK 1.8+
…Read the whole file at its exact version.
How to install
mdr add huaweicloud/huaweicloud-skills/huawei-cloud-dws-migration-teradata-to-dws@sha256:d6a5da63a2adf0e2The line at the top of this page pins the label git:20260929.dbb1d02, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_y732gsnzefodxr3l)
2 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Sep 29, 2026.
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (24462 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
huaweicloud/huaweicloud-skills · 59 stars · license MIT · pushed 2026-11-07 · branch master
API
GET https://markdownregistry.com/api/v1/artifacts/art_y732gsnzefodxr3l GET https://markdownregistry.com/api/v1/resolve?ref=huaweicloud/huaweicloud-skills/huawei-cloud-dws-migration-teradata-to-dws GET https://markdownregistry.com/api/v1/blob/d6a5da63a2adf0e2f0a5a82491e6aa2ab3cd856abdd93af11601123e9de279c3
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.