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…
Keep reading with a 7-day free trial
Subscribe to DataEngineer.io Newsletter to keep reading this post and get 7 days of free access to the full post archives.