snowflake-sql

name	snowflake-sql
description	Snowflake-specific SQL patterns: QUALIFY for window filtering, LATERAL FLATTEN for arrays, semi-structured VARIANT data, ILIKE for case-insensitive matching, date functions, and time travel.
type	skill

Snowflake SQL Skill

1. Window Function Filtering - Use QUALIFY

Instead of wrapping in a subquery, use QUALIFY:

-- Find the latest record per customer
SELECT customer_id, order_date, amount
FROM orders
QUALIFY ROW_NUMBER() OVER (PARTITION BY customer_id ORDER BY order_date DESC) = 1;

-- Top 5 products by sales
SELECT product_id, total_sales
FROM sales_summary
QUALIFY DENSE_RANK() OVER (ORDER BY total_sales DESC) <= 5;

2. Case-Insensitive Matching - Use ILIKE

-- Case-insensitive LIKE
WHERE product_name ILIKE 


 (status)  

 status ILIKE