← Back to Snowflake
3
Design a Time Travel Feature
System DesignhardCommon
time-travelversioningstorage-optimization
Reported
8 times
Last seen
2026-03-18
First seen
2025-06-10
Active in
2025, 2026
Description
Design a system that allows querying historical versions of data with configurable retention. Handle storage optimization.
Approach Tips
Store immutable micro-partitions and use metadata to reconstruct any point-in-time view. Discuss garbage collection for expired retention windows.
Sources
Blind·Staff·2026-03-18
Glassdoor·SDE-3·2025-12-22
SF
Snowflake
Data/Cloud
Typically appears in: Onsite - System Design
60 min — Design a cloud data platform component. Focus on scalability, multi-tenancy, and query performance.