validate-stm

To validate a Source-to-Target Mapping workbook, run automated checks using Python and openpyxl to verify required sheets, column headers, and transformation logic. This generates a severity-ranked report flagging missing lineage traceability and DMS reference gaps to resolve before downstream development.

STM validation is the process of checking Source-to-Target Mapping documents for completeness and quality. It is needed to prevent broken data pipelines, ensure accurate medallion layer transformations, and eliminate costly rework caused by incomplete mapping logic or missing lineage traceability.

Yes, you can run automated transformation checks on STM Excel files in CI/CD pipelines. The validation executes via Python and openpyxl, allowing seamless integration into local development or automated workflows to continuously verify DMS references and lineage coverage.

Yes, openpyxl supports checking DMS traceability and lineage coverage by reading the Excel workbook structure. The validation script uses openpyxl to inspect required STM sheets and column headers, ensuring end-to-end lineage chains and DMS references are completely mapped.

A limitation of using Python for Excel audit is that validation depends on standardized workbook structures. If the STM workbook lacks the required sheets or expected column headers, the openpyxl-based script cannot accurately assess transformation logic or lineage coverage.

The best way to catch mapping gaps is to run an automated STM validation script that checks all 8 required sheets and flags issues by severity. This provides actionable fix recommendations for CRITICAL errors and WARNINGs before handing the document to downstream teams.