Vendor
Snowflake interview themes
What people report studying for — not a take-home dump. Last editorial update 2026-08-18.
Rounds you should expect
Internals
Micro-partitions, clustering vs Search Optimization, Query Profile nodes.
Gen AI specialty
Cortex COMPLETE in ELT vs a BI explore. Analyst vs Search. Token cost per row.
Recently added questions
2026-08-18 · Cortex in a dashboard
A hiring manager asks you to put Cortex COMPLETE in a Looker explore. What do you say?
No. Materialize the label in ELT once, version the prompt, and let BI read a column. Dashboard refresh is a token bill and a non-deterministic metric.
From the question bank
hard · SQL · SQL
NULL = NULL is unknown. How does that bite a MERGE or an anti-join?
Practice →medium · SQL · SQL
QUALIFY vs a CTE for window filters — when do you use each?
Practice →medium · SQL · SQL
A query is correct but scans last year. How do you prove partition pruning?
Practice →easy · SQL · SQL
FILTER (WHERE status = 'paid') on an aggregate vs a CASE. Why mention it?
Practice →medium · Warehouse · Snowflake
Someone DELETED gold.orders. What do you do in the first ten minutes?
Practice →medium · Warehouse · Snowflake
Streams and Tasks vs an external orchestrator. How do you choose?
Practice →medium · Warehouse · Snowflake
Search Optimization vs a clustering key — one sentence each.
Practice →medium · Warehouse · Snowflake
Zero-copy clone of prod for a destructive test. What do you warn finance?
Practice →easy · Warehouse · Snowflake
A share vs an export. When is export still right?
Practice →hard · Warehouse · Snowflake
Dynamic Tables vs Streams + Tasks. Pick one and defend it.
Practice →medium · Warehouse · Snowflake
SnowPro Specialty: Gen AI — where does COMPLETE belong?
Practice →easy · Warehouse · Snowflake
Cortex Analyst returns doubled revenue. First check?
Practice →