If you go back ten years, you’ll see that daily dimensional snapshotting ruled (and continues to rule) the world.
There are tons of drawbacks to daily snapshots such as:
What about intraday changes?
They get squashed and forgotten about
What about pipelines that require the most up-to-date dimensions in a low latency way?
Low-latency use cases either acce…
