Snowflake Interview Questions 2026
Published July 22, 2026 · Updated July 22, 2026
20 Snowflake interview questions from General, Netflix, Airbnb, Deloitte. All difficulty levels, all roles. Upvoted by engineers who were asked them.
20 questions
Companies: General, Netflix, Airbnb, Deloitte
1571 upvotes
Snowflake Questions by Company
General (11)
General
Medium
Scenario round
5–8 YearsSnowflakeAWS S3Python
A file lands in AWS S3 and must be ingested into Snowflake automatically in near real-time. How would you design the solution? Explain the role of Snowpipe, event notifications, and the ingestion workflow.
↑ 67 upvotes · 48 engineers asked this · Data Engineer
General
Medium
Scenario round
5–8 YearsSnowflakeSQL
A production table was accidentally deleted 2 hours ago. How would you recover the data using Snowflake Time Travel?
↑ 79 upvotes · 57 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakeSQL
A critical table was dropped 10 days ago and the Time Travel retention period has expired. What recovery options are available? Explain how Fail-safe works and its limitations.
↑ 61 upvotes · 44 engineers asked this · Data Engineer
General
Medium
Scenario round
5–8 YearsSnowflakeSQL
Your team needs a test environment containing production data without duplicating storage costs. How would you use Zero Copy Cloning and what are its benefits and limitations?
↑ 72 upvotes · 51 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakeSQLPython
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?
↑ 83 upvotes · 59 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakeSQLPython
A query that previously completed in 2 minutes now takes 20 minutes. Describe your systematic approach to troubleshooting and optimizing performance in Snowflake.
↑ 91 upvotes · 65 engineers asked this · Data Engineer
General
Hard
Scenario round
5–8 YearsSnowflakePySparkAirflow
Design an end-to-end data pipeline using Python, PySpark, Snowflake, Airflow, and AWS S3. Explain data flow, orchestration, monitoring, and failure handling.
↑ 87 upvotes · 62 engineers asked this · Data Engineer
General
Medium
Scenario round
5–8 YearsSnowflakeSQL
Compare Snowpipe and COPY INTO. When would you choose one over the other?
↑ 68 upvotes · 49 engineers asked this · Data Engineer
General
Medium
Scenario round
5–8 YearsSnowflakeSQL
Compare Time Travel and Fail-safe in Snowflake. What are the key differences and use cases for each?
↑ 64 upvotes · 46 engineers asked this · Data Engineer
General
Medium
Scenario round
5–8 YearsSnowflakeSQL
Compare Temporary, Transient, and Permanent tables in Snowflake. When would each table type be appropriate?
↑ 71 upvotes · 52 engineers asked this · Data Engineer
General
Medium
Scenario round
5–8 YearsSnowflakeSQL
Compare Streams and Tasks in Snowflake. How do they work together to support Change Data Capture (CDC) workflows?
↑ 77 upvotes · 55 engineers asked this · Data Engineer
Netflix (1)
Netflix
Hard
System Design round
5–8 YearsPythonKafkaSnowflake
Design a data pipeline to ingest CDC (Change Data Capture) events from a MySQL database into a Snowflake data warehouse in near real-time.
↑ 131 upvotes · 103 engineers asked this · Data Engineer
Airbnb (1)
Airbnb
Hard
Scenario round
4–7 YearsPythonSnowflake
Your team discovers that 20% of user_id values in the orders table do not match any record in the users table. How do you handle this as a data engineer?
↑ 102 upvotes · 81 engineers asked this · Data Engineer
Deloitte (3)
Deloitte
Hard
Technical round
3–6 YearsSnowflake
Explain Snowflake multi-cluster architecture. How does it handle concurrency, and what is the difference between a Virtual Warehouse and the Cloud Services layer?
↑ 94 upvotes · 74 engineers asked this · Data Engineer
Deloitte
Medium
Technical round
2–5 YearsSnowflakeSQL
What is Time Travel in Snowflake and how does it differ from Fail-Safe?
↑ 81 upvotes · 64 engineers asked this · Data Engineer
Deloitte
Medium
Technical round
2-6 yearsSnowflake
What is the difference between Snowpipe and a traditional batch COPY INTO for loading data into Snowflake? When would you choose each?
↑ 19 upvotes · 10 engineers asked this · Data Engineer
Adobe (1)
Adobe
Hard
Technical round
4–7 YearsSnowflakeSQL
Your Snowflake query is slow even with a large warehouse. How do you investigate and optimize it?
↑ 107 upvotes · 84 engineers asked this · Data Engineer
Capital One (1)
Capital One
Medium
Technical round
3–5 YearsSnowflake
What is Zero-Copy Cloning in Snowflake and when would you use it in a data pipeline?
↑ 88 upvotes · 69 engineers asked this · Data Engineer
Canva (1)
Canva
Hard
Scenario round
5–8 YearsSnowflakeSQL
You have a 10TB Snowflake table queried daily by 50 analysts with very different filter patterns. How do you optimize it?
↑ 113 upvotes · 89 engineers asked this · Data Engineer
Snowflake (1)
Snowflake
Medium
Technical round
2-5 yearsSnowflake
What is the difference between scaling a Snowflake virtual warehouse "up" versus "out"? When would you use each?
↑ 16 upvotes · 7 engineers asked this · SDE2
Practice these questions with AI feedback
Get instant grading on your answers, identify your weak areas, and generate a personalised 14-day study plan — all free.
Build my study plan →
Snowflake questions at each company
Frequently asked questions
A file lands in AWS S3 and must be ingested into Snowflake automatically in near real-time. How would you design the solution? Explain the role of Snowpipe, event notifications, and the ingestion workflow.
A file lands in AWS S3 and must be ingested into Snowflake automatically in near real-time. How would you design the solution? Explain the role of Snowpipe, event notifications, and the ingestion workflow.
A production table was accidentally deleted 2 hours ago. How would you recover the data using Snowflake Time Travel?
A production table was accidentally deleted 2 hours ago. How would you recover the data using Snowflake Time Travel?
A critical table was dropped 10 days ago and the Time Travel retention period has expired. What recovery options are available? Explain how Fail-safe works and its limitations.
A critical table was dropped 10 days ago and the Time Travel retention period has expired. What recovery options are available? Explain how Fail-safe works and its limitations.
Your team needs a test environment containing production data without duplicating storage costs. How would you use Zero Copy Cloning and what are its benefits and limitations?
Your team needs a test environment containing production data without duplicating storage costs. How would you use Zero Copy Cloning and what are its benefits and limitations?
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?
Snowpipe is ingesting duplicate records from cloud storage. How would you detect, prevent, and remediate duplicate data in Snowflake?