What is a snapshot in the context of Data warehousing?
Data warehouse snapshots can be used to track activities. An employee changing his address, for example, can alert the data warehouse for a snapshot to be taken. Whenever an event occurs, a snapshot is taken.
A snapshot in this regard has three components β
- The time when the event occurred.
- A key to identifying the snapshot.
- Data that relates to the key.





