InterviewLegend

Arrays, Strings & Intervals

Alex Chen24 min readUpdated 111 real interview reports

Snowflake's loud coding signatures are topological sort and build-a-data-structure. This lesson is the rest of the room: the sliding-window, two-pointer, hashing, heap, interval, and stack problems that fill out a phone screen or a second onsite slot. They are not the headline, but they show up, and a few of them show up a lot. A Premium question lands in Snowflake reports about as often as any string problem in the set. Merge k Sorted Lists, a Premium question, Trapping Rain Water, Top K Frequent, a Premium question: all recurring, all in this band.

These read like standard mediums and the occasional hard. The catch is what gets stapled on. Snowflake is a data warehouse, so a problem that looks like "find the shortest window" arrives as "aggregate this log without scanning it twice." The grade rides on whether your structure holds at a billion rows; reciting the algorithm is not enough. Same patterns everyone drills. A scale clause you have to hear.

The Snowflake angle
Restate the inputs, the scale, and the edge cases before you type. Candidates fail this loop by skipping it. Snowflake interviewers want the requirements pinned first, then correct code, then a defense of the time and space. A medium-looking prompt usually has a data-scale twist folded in, and diving straight at a solution misses it. Ask how big the input gets, whether it streams or sits in memory, whether values can repeat or go negative. Then pick the structure that answers the scale, not just the example; the first two minutes are graded.
What's inside
  • 3 problems, worked step by step
  • about 24 min

Premium lessonSnowflake interview guide

These took digging.

What candidates walked out with, from 20,000+ reports, forum threads behind logins and write-ups in Chinese. Then solved step by step.

100 companies. Checked every month.

Unlock all 100 companies

$49 a year · less than $1 a week · Cancel anytime

Had your Snowflake interview?Tell us what they asked. Reviewed before it goes in, never with your name.
Snowflake interview guide

Know what Snowflake asks before you walk in.

10 coding · 5 system design · 18 behavioral questions

Get Premium$49 a year · Cancel anytime
Or start freeNo card.

Get their questions first.

InterviewLegend is independent and not affiliated with or endorsed by any company it covers.