← Back to Snowflake
4
Build a Result Cache System
CodingmediumCommon
cachingquery-resultsinvalidation
Reported
6 times
Last seen
2026-03-15
First seen
2025-08-18
Active in
2025, 2026
Description
Implement a query result caching system that handles cache invalidation on data changes and metadata-only queries.
Approach Tips
Cache key should include query text + table versions. Invalidate when underlying data changes. Discuss metadata-only queries that return cached results instantly.
Related LeetCode Problem
LC #146 - LRU Cache
Sources
Blind·SDE-2·2026-03-15
Glassdoor·SDE-3·2025-10-25
SF
Snowflake
Data/Cloud
Typically appears in: Phone Screen
60 min — Algorithmic coding problem with focus on data structures and efficiency.