SCD via SQL
Slowly Changing Dimensions (SCD) is a data engineering technique to track changes in a record over time. They're useful when changes are unpredictable, infrequent, and a historical vew of the data is needed.
SQL is ubiquitous in data engineering, and therefore it is the perfect tool to implement SCD with.
12 May 2023