Time Travel versus Slowly Changing Dimension Type 2

5 min readAug 17, 2022

The motivation for writing this article is to help readers realize and recognize the opportunity to utilize the Delta Lake time travel feature when faced with a problem that involves analyzing historical versions of a record (slowly changing dimension type 2). Additionally, I hope to help readers understand when to stick to Slowly changing dimension type 2 implementation instead of time travel.

Time Travel VS SCD II

I am passionate about empowering and encouraging people of color in the data analytics career path