How to Track History in a Data Warehouse (Slowly Changing Dimensions)
Feb 14, 2025Have you ever had a stakeholder ask to see historical changes to some data over time?
Only realize you don’t have a good way to show that.
This is a common scenario but also something data teams struggle with quite often.
Fortunately, this is a known problem that can be solved by creating what’s known as a Slowly Changing Dimension in your data model.
But actually implementing this type of table can be confusing if you don’t understand the options and trade-offs.
So in this video, you’ll learn more about the two most common types of slowly changing dimensions, different columns you can add to help with tracking changes and personal advice for how to put it all together successfully.
Enjoy.
When you're ready, here are 2 other ways I can help you:
1. Simple Stack Academy: Level-up your data career by learning more than just SQL. Design, build & automate an end-to-end data architecture using modern tools like dbt⢠& Github. (Free 7 Day Preview)
2. Consulting Services: Get personalized support to properly implement a well-structured, scalable, and maintainable data architecture at your company.