query.lab
all companies

Snowflake SQL interview questions

Warehouse-centric SQL — semi-structured data, performance and modeling. Practice reconstructed Snowflake-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.

sqlpythonpandaseasy3medium8hard5

typical interview loop

  1. 1.Recruiter screen
  2. 2.Technical screen: SQL plus a Python data-manipulation exercise
  3. 3.Onsite: data modeling / pipeline design, coding, behavioral
  • › Know QUALIFY-style filtering via window functions.
  • › Discuss clustering and query cost.

most-tested topics

filtering
4
JOIN
3
Window functions
3
GROUP BY
2
groupby
2
SUM
1

Based on 16 reconstructed Snowflake-style questions.

practice path

1 free · 15 Pro
type
level
  1. 1Credits per warehousesqleasy
  2. 2Failed queries by usersqleasy
  3. 3Warehouse size orderingpythoneasy
  4. 4Active shares per databasesqlmedium
  5. 5Auto-suspend savingspythonmedium
  6. 6Average scan size per warehouse sizesqlmedium
  7. 7Credit efficiency per warehousesqlmedium
  8. 8Poorly clustered tablessqlmedium
  9. 9Queries that spilled to remote storagesqlmedium
  10. 10Scan efficiency per warehousepandasmedium
  11. 11Spill rate by userpandasmedium
  12. 12Credits with cumulative sharepandashard
  13. 13Day-over-day credit changesqlhard
  14. 14Detect query gaps and islandspythonhard
  15. 15Share of credits per warehousesqlhard
  16. 16Slowest query per usersqlhard

Unlock all 16 Snowflake questions with Pro.

upgrade