des-silver-layer-design

Design Silver-layer entity and event datasets with Bronze mappings and quality rules.

2|Updated May 20, 2026
One-click install
npx skills add https://github.com/DKSang/DES-SKILL --skill des-silver-layer-design
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: des-silver-layer-design
Source: https://github.com/DKSang/DES-SKILL/tree/main/skills/des-silver-layer-design
Command: npx skills add https://github.com/DKSang/DES-SKILL --skill des-silver-layer-design

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It helps you design a Silver layer that turns Bronze- and source-derived data into cleaned, conformed, deduplicated, keyed, validated, privacy-handled, and traceable entity/event datasets that downstream Gold design can safely consume.

Core Features & Use Cases

  • Silver Layer Specification creation: Define scope, non-scope, design principles, and a complete Silver-to-Bronze mapping.
  • Data conformance & trust rules: Specify grain, identity, key strategy, deduplication/survivorship, standardization, normalization, and boundary data quality rules.
  • Governance-ready evidence & handoff: Produce Phase 10 support plan, evidence pack, artifact revision, Done Gate, and Phase 10→11 handoff with explicit HALT-driven decisions.

Quick Start

Use the des-silver-layer-design skill to generate the Silver Layer Specification at _des-output/planning-artifacts/10-silver-layer-specification.md from an existing Phase 09 Bronze Layer Specification and Phase 09→10 handoff.

Frequently Asked Questions about des-silver-layer-design

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

FAQPage Schema
What is a silver layer in data engineering and why is it needed?

A silver layer transforms bronze and source-derived data into cleaned, conformed, deduplicated, keyed, validated, and traceable entity/event datasets. It ensures downstream gold marts safely consume trusted, privacy-handled, and lineage-trackable data.

How do I design a silver layer dataset from bronze source data?

Design silver datasets by specifying scope, bronze-to-silver mappings, grain, identity, key strategy, deduplication, and data quality rules. You also define standardization, normalization, privacy handling, and lineage requirements to produce a complete silver layer specification.

What data conformance and deduplication rules are needed for silver layer entity modeling?

Data conformance requires defining grain, identity, key strategy, survivorship rules for deduplication, and boundary data quality rules. Standardization and normalization rules are also specified to ensure silver entity and event datasets remain consistent and trusted.

Do I need a bronze layer specification before designing silver entity and event datasets?

Yes, designing silver requires an existing Phase 09 bronze layer specification and handoff. If these bronze inputs are unavailable, you must explicitly accept the associated risks before proceeding with silver layer design and phase handoff.

Can I design gold marts, semantic models, or orchestration code within a silver layer design phase?

No, silver layer design enforces strict guardrails against designing gold marts, semantic models, orchestration, CI/CD, or transformation code. It strictly focuses on silver entity and event datasets to prevent scope creep into downstream architectural layers.

What outputs and evidence artifacts are produced for silver layer governance handoff?

Outputs include the silver layer specification, support plan, evidence pack, artifact revision, Done Gate, and Phase 10 to 11 handoff. These governance-ready artifacts capture explicit HALT-driven decisions to ensure downstream traceability and compliance.