validate-silver

Detect drift between Silver data layer implementations and approved design artifacts.

5|1|Updated Sep 23, 2025
One-click install
npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill validate-silver
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: validate-silver
Source: https://github.com/RDEWAI/Redefining-DataEngineering-With-AI/tree/main/chapter-6/developer-plugin/skills/validate-silver
Command: npx skills add https://github.com/RDEWAI/Redefining-DataEngineering-With-AI --skill validate-silver

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill eliminates the risk of undetected drift between Silver data layer implementations and approved upstream design artifacts (LLD, DMS, STM, DQS), which can cause production data quality failures, compliance gaps, and costly rework when promoting code to production.

Core Features & Use Cases

  • 27 Severity-Ranked Validation Rules: Checks module presence, schema alignment, SCD2 wiring, data quality gate ordering, Airflow DAG structure, and artifact traceability, flagging issues as CRITICAL, WARNING, or INFO.
  • Pre-Promotion Audit: Use this Skill to review Silver code before promotion to catch misalignments with design specs early in the development workflow.
  • CI/CD Integration: Supports JSON output format for automated pipeline checks, with exit codes that fail builds on critical findings.

Quick Start

Use the validate-silver skill to audit your patient_360 Silver layer implementation against the latest approved upstream design artifacts and receive a severity-ranked drift report.

Frequently Asked Questions about validate-silver

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

FAQPage Schema
Can I integrate Silver layer validation into a CI/CD pipeline?

Yes, you can enforce Silver layer validation in CI/CD pipelines using JSON output and exit codes. This automation fails builds when critical data quality gate ordering or Airflow DAG wiring issues are detected.

What does SCD2 validation check for in a data engineering project?

SCD2 validation checks the wiring and configuration of Slowly Changing Dimensions within the Silver layer. It ensures your data quality gate ordering and schema alignment match the approved upstream design artifacts to prevent drift.

How do I detect upstream drift in an Airflow DAG before production promotion?

Detect upstream drift by running a pre-promotion audit that executes severity-ranked checks on your Airflow DAG structure and artifact traceability. This identifies misalignments with LLD and DMS specifications early.

Does Silver layer validation work for patient 360 data engineering projects?

Yes, Silver layer validation is scoped specifically for patient 360 data engineering projects. It enforces alignment with STM Bronze-to-Silver and DQS specifications to catch compliance gaps during development.