Snowflake Interview Questions
Curated from verified interview reports: data-platform-flavored Coding and OA rounds - API throttling, pipeline throughput, access-rights inheritance, and a resizable LRU cache.
7 real interview questions reported from Snowflake Software Engineer interviews (Coding, OA rounds): 5 medium, 2 hard. Each question shows its interview round and how often it was reported, and coding questions come with runnable tests.
Snowflake Coding round questions (5)
- API Throttle Manager - Medium, free preview
Simulate an API gateway that must satisfy several sliding-window rate limits at the same time. - Inherited Access Rights - Hard, free preview
Propagate allow and deny rights through a DAG where any inherited deny must override every allow. - Pipeline Throughput Optimizer - Hard
Spend a limited upgrade budget to raise the slowest stage of a sequential pipeline as much as possible. - Product Sales Ranker - Medium
Track cumulative product sales and return the current top sellers with deterministic tie-breaking. - Resizable LRU Cache - Medium
Implement a standard LRU cache, then handle the twist that capacity can change at runtime.
Snowflake OA round questions (2)
- Complete Vowel Substrings - Medium
Count vowel-only substrings that contain all five vowels at least once without falling into an O(n²) trap. - Work Schedule Generator - Medium
Fill a 7-day schedule pattern so the completed week hits an exact target hour total and stays lexicographically sorted.