snowflake interviews are SQL-heavy which makes sense: 1. write a query to find the top 5 customers by revenue in each region using window functions 2. optimize a slow query that joins 3 tables with 100M+ rows. explain the query plan 3. system design: design a distributed query execution engine 4. coding: implement a simple columnar storage format with compression the SQL rounds were straightforward if you know window functions and query optimization

Snowflake senior - SQL heavy interview

snowflake interviews are SQL-heavy which makes sense: 1.

snowflake asking you to design snowflake is the ultimate flex. "design our $50B product in 45 minutes please"

the columnar storage with compression problem - did they ask about run-length encoding vs dictionary encoding vs delta encoding?