Announcing our $3.4M seed round 🚀 Read more →

How to Write a Case Statement in Snowflake in Snowflake

Case statements are useful when you're reaching for an if statement in your selectclause.

select
  id, 
  name, 
  category,
  unit_price,
  case 
    when category = 5 then 'Premium'
    when category = 4 then 'Gold'
    when category = 3 then 'Standard'
    when category <= 2 then 'Basic' 
    else 'unknown'
  end as quality_level
from products;

Ready for a modern SQL editor?