skills.rest
RDEWAI
RDEWAIOFFICIAL
Explore all skills by this author →
GitHub

update-stm

Update Source-to-Target Mapping Excel workbooks with schema changes and transformation rules.

5|1|Updated Sep 23, 2025
Search Tags:#data engineering#medallion architecture#stm#excel workbook#source-to-target mapping#dms schema#transformation rules
One-click install
npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill update-stm
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: update-stm
Source: https://github.com/RDEWAI/Redefining-DataEngineering-With-AI/tree/main/chapter-6/mapping-analyst-plugin/skills/update-stm
Command: npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill update-stm

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually updating large Source-to-Target Mapping (STM) Excel workbooks is time-consuming and error-prone, especially when Data Model Specifications (DMS) change, new source tables are added, or transformation rules are revised. This Skill automates the update process while preserving existing work and maintaining full traceability.

Core Features & Use Cases

  • Merges DMS schema changes, new transformation rules, and revised null handling strategies into existing STM workbooks
  • Preserves all unchanged sheets, auto-increments version numbers, and logs changes in the Summary sheet
  • Enforces cross-sheet consistency, DMS traceability, and read-only source metadata verification to prevent invalid mappings
  • Use case: Data engineering teams can quickly apply approved DMS updates to medallion-layer mapping documents without risking overwrite of existing, validated work.

Quick Start

Use the update-stm skill to revise the latest STM Excel workbook with the new lab result column mappings from the updated DMS file.

Frequently Asked Questions about update-stm

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I update an existing Source-to-Target Mapping Excel workbook with new DMS schema changes?▼

You can update a Source-to-Target Mapping workbook by automatically merging new DMS schema definitions, transformation rules, and null handling strategies while preserving unchanged sheets and enforcing cross-sheet consistency.

What is the best way to apply revised transformation rules to medallion-layer mapping documents?▼

The best way to apply revised transformation rules to medallion-layer mapping documents is to automate the merge process, ensuring full DMS traceability and version tracking without overwriting previously validated mapping work.

How does source-to-target mapping handle traceability when Data Model Specifications change?▼

Source-to-target mapping handles traceability by enforcing DMS traceability and logging all schema, transformation, and null handling changes in a Summary sheet while auto-incrementing the workbook's version number.

Can I verify read-only source metadata when updating STM workbooks?▼

Yes, updating STM workbooks includes read-only source metadata verification to prevent invalid mappings, ensuring that new source tables and changed business rules align correctly with the updated Data Model Specifications.

Does updating STM workbooks preserve existing validated data engineering mappings?▼

Yes, updating STM workbooks preserves all unchanged sheets and existing validated mappings, applying only the approved DMS updates and new column mappings while maintaining cross-sheet consistency.

When do I need to automate source-to-target mapping workbook updates?▼

You need to automate source-to-target mapping updates when Data Model Specifications change, new source tables are added, or transformation rules are revised, preventing manual errors in large medallion-layer mapping documents.

Related Skills

Explore More Data & Analytics Skills→
RDEWAIRDEWAI
5

create-stm

Generate standardized source-to-target mapping Excel workbooks for medallion data pipelines.

Official
Advanced
RDEWAIRDEWAI
5

update-stories

Updates sprint backlogs for data engineering projects when design artifacts, capacity, or priorities change.

Official
Advanced
aiyinluyaaiyinluya
2

excel-multi-sheet-dynamic-analysis

Analyze multi-sheet Excel workbooks to produce cross-sheet statistics and summary reports.

Community
Advanced
RDEWAIRDEWAI
5

validate-stm

Validate Source-to-Target Mapping Excel workbooks for completeness and quality.

Official
Advanced