I've built this a few times as well. They all revolve around known patterns, https://en.wikipedia.org/wiki/Slowly_changing_dimension https://en.wikipedia.org/w

I've built this a few times as well. They all revolve around known patterns, https://en.wikipedia.org/wiki/Slowly_changing_dimension https://en.wikipedia.org/wiki/Slowly_changing_dimension I highly doubt there's a single way to do this that solves every scenario.