Building the Gold Layer in dbt | Config Tables & Testing

Building the Gold Layer in dbt | Attrition Model | Config Tables & Testing In this video, we dive deep into building the Gold Layer of our data warehouse project, focused on the Employee Attrition Model. From planning to practical implementation, this is a complete walkthrough of how we structure, build, and test production-ready gold layer models in dbt with Snowflake. 📌 What's Covered: 🔹 Theory & Planning — What we're building in the gold layer and how we approach the design before writing a single line of code 🔹 Silver Layer Inputs — Which tables and fields we're bringing in from the silver layer as the foundation for our models 🔹 Layer Buckets — How we organise and segment data within the gold layer for clarity and performance 🔹 Flag Engineering — The business logic flags we create in this layer to power downstream reporting and decision-making 🔹 Model Overview — A walkthrough of all the individual models we'll be building in the gold layer 🔹 Practical Implementation — Live coding session building out the gold layer dbt models end to end 🔹 Dynamic Config Tables — How we set up configuration tables in Snowflake so that business users can update thresholds directly — no dbt redeployment needed, just run and it picks up the change automatically 🔹 YML & Testing — Adding the yml schema file for gold layer models and writing tests to ensure data quality and reliability ⏱️ Timestamps: 1:00 — Gold Attrition Model Theory & Planning 1:55 — Items Brought from Silver Layer 2:55 — Buckets in the Gold Layer 3:45 — Flags Created in This Layer 7:29 — Models We'll Build in the Gold Layer 8:00 — Practical Implementation 21:15 — Config Tables for Dynamic Threshold Management 38:15 — YML File & Testing for Gold Layer Models If you found this helpful, like and subscribe for more content on dbt, Snowflake, and modern data engineering! #dbt #dbttutorial #dbtcore #dataengineering #dataengineer #dataengineeringessentials #dataengineer #de #analyticsengineering #analyticsengineer