update-stm

Name: update-stm
Availability: InStock
Author: RDEWAI

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

Ready to run

npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill update-stm

💬 Prompt for ChatGPT / Claude Chat▼

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.