Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab

Welcome to dimensional Data Modeling Day 2 lab. Today is gonna be a hands-on exercises that builds on the day one lab where we built a cumulative table that tracks all of the NBA players' seasons and their stats throughout the seasons. This time around we are going to be taking those data sets and converting them into slowly changing dimension type 2 because remember slowly changing dimension type 2 is the gold standard of all the slowly changing dimension types. It's the only one that is purely item potent, so we're gonna be using postcress in today's lab. If you don't have the stuff installed, make sure to clone the repo in the description below. You're gonna need Docker installed and you're gonna need to have that set up before. The lab to get the most out of this because this is hands on exercises and we learn data engineering by doing here. And yeah, if you want to learn how to do this type of modeling with the hottest technologies like iceberg and Trino, I highly recommend checking out joining the Data Expert Academy in the description below. First, we need to like probably drop and recreate the players' table. I made a mistake in the last lab where like I didn't add the columns that I wanted for this lab, and I forgot that these labs like build on top of each other.