Medallion Architecture Accelerator
Production implementation of Bronze/Silver/Gold architecture on Databricks with metadata-driven pipeline generator and quality gates.
📄 Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample📁 File Structure 34 files
📖 Documentation Preview README excerpt
Medallion Architecture Accelerator
By [Datanest Digital](https://datanest.dev) | Version 2.0.0 | $79
Production-ready framework for implementing the Medallion Architecture (Bronze / Silver / Gold) on Databricks with Delta Lake. Eliminate weeks of boilerplate and enforce best practices from day one.
v2.0 adds a comprehensive 10-chapter implementation guide, quick-reference cheatsheets, architecture diagrams, plus naming convention and schema migration utilities.
What You Get
Production Framework (`framework/`)
#### Bronze Layer (Raw Ingestion)
- Base Ingestor -- Schema evolution, exactly-once semantics, source lineage tracking
- Auto Loader Ingestor -- Cloudfiles-based streaming ingestion with rescue columns
- JDBC Ingestor -- Incremental extraction from relational databases with watermark tracking
#### Silver Layer (Conformed / Cleansed)
- Base Transformer -- Deduplication, type casting, null handling, data conformance
- SCD Type 2 -- Slowly-changing dimension management with merge-based upserts
#### Gold Layer (Business / Aggregated)
- Aggregation Builder -- Business KPIs, time-series rollups, dimensional model support
- Fact Table Builder -- Star-schema fact tables with conformed dimension joins
#### Utility Tools (New in v2.0)
- Naming Convention Generator -- Enforce consistent table/column/path naming across your lakehouse
- Schema Migration -- Track and apply schema changes across medallion layers with full audit trail
Pipeline Generation (`config/`)
- Metadata-Driven Generator -- Define sources in YAML, generate all three layers automatically
- Example Configs -- Five pre-built source configurations covering common patterns
Quality & Optimization
- Quality Gates (
quality/) -- Null checks, schema validation, business rules, inter-layer assertions - Delta Optimization (
optimization/) -- OPTIMIZE, ZORDER, VACUUM, liquid clustering per layer tier - Layer Tests (
testing/) -- Unit and integration testing framework for every layer
10-Chapter Implementation Guide (New in v2.0) (`docs/guide/`)
A complete, opinionated guide to designing, building, and operating a medallion lakehouse:
| Chapter | Topic | What You'll Learn |
|---|---|---|
| 01 | Introduction | Why medallion, when to use it, core principles |
| 02 | Decision Framework | How to decide if medallion fits your use case |
| 03 | Bronze Layer | Ingestion patterns, schema evolution, exactly-once |
| 04 | Silver Layer | Cleansing, conformance, deduplication, SCD |
| 05 | Gold Layer | Aggregations, dimensional modeling, materialized views |
| 06 | Naming Conventions | Databases, tables, columns, paths -- consistent naming |
| 07 | Schema Evolution | Safe schema changes, migration strategies, compatibility |
| 08 | Data Quality Gates | Null checks, business rules, inter-layer assertions |
| 09 | Anti-Patterns | Common mistakes and how to avoid them |
| 10 | Reference Architectures | Three complete architectures (startup → enterprise) |
Quick-Reference Cheatsheets (New in v2.0) (`docs/cheatsheets/`)
- Layer Comparison -- Side-by-side comparison of Bronze vs Silver vs Gold responsibilities
- Migration Checklist -- Step-by-step checklist for migrating existing pipelines to medallion
... continues with setup instructions, usage examples, and more.