How Snowflake Interviews in 2026: Process, Questions & What They Score

• Given an array of intervals and a new interval, adjust the array to fit the new interval.Tests merging and overlap-resolution logic on sorted interval data.
• Write a class that processes a stream of input.Tests API and state design for a component that must handle data incrementally.
• Given a string, check whether any character has been duplicated.Tests hashing or bit-set technique for character frequency under follow-up constraints.
• Design a transactional in-memory key-value store.Tests implementing begin, commit and rollback semantics with correct isolation.
• Design a priority task executor with duplicate task IDs.Tests priority queue design plus idempotent handling of duplicate task identifiers.
• Prune an N-ary or multiway tree to a maximum depth limit.Tests recursive tree traversal and pruning under deliberately vague requirements.
• Resolve inherited allow and deny permissions in a DAG, then compute effective permissions.Tests graph traversal to resolve conflicting inherited permission rules.
• Implement topological sort and tree boundary traversal.Tests topological sort on a DAG and level-order boundary traversal of a tree.
• Deep-copy a linked list with random pointers.Tests hash-map cloning technique for a linked list with extra random pointers.
• Query unique and most-frequent keys in a recent event window.Tests sliding-window counting structures for recency-bounded frequency queries.
• Traverse all reachable pages with parallel BFS, and implement a concurrent web crawler.Tests parallel BFS plus thread-safe visited-set tracking for concurrent crawling.
• Merge k sorted lists.Tests heap-based or divide-and-conquer merging of multiple sorted lists.
• Maximum profit in job scheduling.Tests interval scheduling with dynamic programming plus binary search.
• Implement an LRU cache.Tests combining a hash map with a doubly linked list for O(1) cache operations.
• Decode an encoded string (Decode String).Tests stack-based parsing of nested bracketed repeat-count encodings.
• Build an ID generator that produces unique IDs.Tests designing a collision-free, concurrency-safe unique identifier generator.

Reported problems, listed so you know what to expect. Practice them in your own editor or on the platform you prefer; SupaCV's practice mode coaches how you talk through them.

• Design a query result cache for a multi-tenant data warehouse handling 100K queries per minute.Tests cache invalidation strategy and tenant isolation at high query throughput.
• Design a data security and governance system.Tests modeling access policies, masking rules and audit requirements at scale.
• Design a system like YouTube, then implement the cache layer.Tests moving from high-level architecture into a concrete, coded caching layer.
• Take in events that happened at a certain time, keep track of and organize them so that you can retrieve them quickly, and insert new events quickly while keeping track of the tradeoffs.Tests choosing and justifying a data structure tradeoff for time-indexed event storage.
• Design a distributed rate limiter, thread-safe and supporting multiple rules.Tests concurrency control and rule composition for a shared rate-limiting service.
• Design an RPC system.Tests serialization, transport and failure-handling design for remote procedure calls.
• Design a metadata service for a cloud data warehouse.Tests schema and API design for a service tracking table and query metadata.
• Design a cron job scheduler, or a reliable job scheduler.Tests scheduling guarantees such as retries, idempotency and missed-run recovery.
• Design a disk-backed key-value store under contention.Tests durability, locking and concurrency control for a persistent key-value store.
• Design a cache for DAG-based query views.Tests cache-key and invalidation design for dependent, DAG-structured query results.
• Design an audit logs service.Tests append-only log storage, immutability and query design at scale.
• Design a multi-tenant quota system.Tests rate accounting and isolation guarantees across tenants sharing capacity.
• Design an ACL authorization checking service.Tests access-control-list modeling and low-latency permission-check design.
• Design an object store with deduplication.Tests content hashing and reference counting to deduplicate stored objects.
• Design an in-memory file system.Tests directory-tree data modeling and file operation APIs entirely in memory.

Reported problems, listed so you know what to expect. Practice them in your own editor or on the platform you prefer; SupaCV's practice mode coaches how you talk through them.

• Explain how Snowflake's multi-cluster shared-data architecture differs from a traditional shared-nothing MPP database.Tests understanding of storage-compute separation versus shared-nothing MPP design.
• Write a SQL query to find the top 10 customers by revenue growth quarter-over-quarter, given an orders table.Tests window functions or self-joins to compute period-over-period growth.
• Department top three salaries (SQL).Tests window functions or correlated subqueries to rank values within groups.
• What are the most important factors to consider when designing a scalable application?Tests grasp of scalability factors such as partitioning, caching and bottlenecks.
• What sorting algorithms do you know, and which one is best?Tests recall and tradeoff comparison of standard sorting algorithms.
• How would you handle debugging a major code issue in an environment like Snowflake?Tests systematic debugging approach in a large, unfamiliar production codebase.

Reported problems, listed so you know what to expect. Practice them in your own editor or on the platform you prefer; SupaCV's practice mode coaches how you talk through them.

• Tell me about a time when you took ownership over a project, and why.
• Tell me about a time you made a mistake.
• Tell me about a time when you wouldn't have successfully completed a project without teamwork.
• Describe a time when you had to work effectively with another team that you had never worked with before.
• Tell me about a time you disagreed with a teammate.
• How do you prioritize when you have competing deadlines?
• Describe a challenging project and how you overcame obstacles.
• Tell me about a time you had to deeply understand a system you didn't build.
• Walk me through a recent project and your specific contribution.
• What's the hardest technical challenge you've faced, and how did you resolve it?
• Describe a technical decision you made and the tradeoffs involved.
• Why do you want to work at Snowflake?
• What interests you specifically about working with data warehousing and cloud platforms?
• Can you describe an instance where you had to innovate in your designs or development process?
• Snowflake has recently launched data sharing features, like Data Marketplace. How would you contribute to improve such features?

Snowflake's process has 9 stages, in order: Application and resume screen, Initial screen with recruiter or hiring manager, Online assessment (HackerRank or CodeSignal), Hiring manager call, Technical screen (live coding, sometimes plus system design), Panel interviews / virtual onsite loop, Tech talk / project presentation (level-dependent), Debrief and decision, Offer, reference checks and background check.

Snowflake evaluates candidates against Our Values: Put Customers First, Integrity Always, Think Big, Be Excellent, Make Each Other The Best, Get It Done, Own It, Embrace Each Other's Differences.

Snowflake's question bank spans 4 categories: Coding and algorithms; System design and distributed systems; Database internals, SQL and fundamentals; Behavioral and values.

This playbook is medium confidence, compiled from 18 public sources, and last verified September 6, 2026. It describes one well-documented shape of Snowflake's interviews, not a guarantee of what any individual loop will look like.