← Back to Dashboard

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.