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

approve-stm

Approve Source-to-Target Mapping Excel workbooks by updating their status.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Manually updating Source-to-Target Mapping (STM) workbook approval status in Excel is time-consuming and error-prone, creating bottlenecks that delay critical downstream data engineering work like data quality specs, logical data models, and user stories.

Core Features & Use Cases

  • Automated STM Status Update: Automatically locates the latest STM Excel file (or uses a user-provided path) and updates its status to Approved, along with the last modified date.
  • Pre-Approval Safety Checks: Validates that the STM is not already approved, warns users if the STM is still in Draft status (and has not undergone review), and recommends running validation first to avoid errors.
  • Audit Logging: Records approval details including file name, version, and previous status to a dated session memory file for traceability.
  • Use Case: A mapping analyst finishing a review of a finalized STM can use this skill to formally sign off on the mapping in seconds, immediately enabling the rest of the data engineering team to start building downstream artifacts without waiting for manual status updates.

Quick Start

Ask the AI to approve the latest Source-to-Target Mapping workbook to mark it as ready for downstream artifact creation.

Frequently Asked Questions about approve-stm

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

FAQPage Schema
How do I automate updating Source-to-Target Mapping workbook status to Approved?▼

You can automate Source-to-Target Mapping (STM) status updates by using a skill that locates the latest Excel file and updates its status to Approved along with the last modified date, eliminating manual Excel edits and status tracking errors.

What happens if I try to approve an STM workbook that is already approved or still in Draft?▼

The STM approval process includes pre-approval safety checks that validate the existing workbook status to prevent duplicate approvals, warn users if the file is still in Draft, and recommend running validation first to avoid errors.

Do I need openpyxl to update Excel workbook approval status for data engineering workflows?▼

Yes, you need the openpyxl library installed because it provides the underlying Excel manipulation capabilities required to locate the Source-to-Target Mapping workbook and update its status fields programmatically.

When do I need to formally approve a Source-to-Target Mapping file?▼

You need to formally approve a Source-to-Target Mapping file after the STM review is complete, which gates the start of downstream data engineering artifact creation including data quality specs, logical data models, and user stories.

How is STM workbook approval audited and tracked for traceability?▼

STM workbook approval actions are audited by logging details including file name, version, and previous status to a dated session memory file, ensuring full traceability for mapping analysts and data engineering teams.

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

create-lld

Generate a 14-section Low-Level Design document from approved data engineering artifacts.

Official
Advanced
opencodosopencodos
14

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Intermediate
RDEWAIRDEWAI
5

update-stm

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

Official
Advanced