MIN_BY and MAX_BY in Snowflake
How to use MAX_BY and MIN_BY in Snowflake (and DuckDB, BigQuery, Databricks) to replace messy self-joins and windows when getting latest or top-N values per group.
Optimization
Snowflake Query Optimization: 7 Tips for Faster Queries
A deep dive into 7 fundamental tips for Snowflake query optimization: pruning, join optimization, clustering, cache, and more for faster queries.
ASOF JOINs in Snowflake: 100x Performance on Time-Relative Joins
ASOF JOINs are the most efficient way to relate the timestamp of one table with the timestamp of another table, even when those timestamps don't match exactly.
Feel free to skip
A Guide to Snowflake's Query Profile
If you've ever written a SQL query, chances are you've encountered a query that had you twiddling your thumbs. Learning how to read Snowflake's Query Profile is
Understanding Snowflake Compute Costs and Credit Consumption
When it comes to managing your Snowflake expenses, understanding how compute costs are calculated and optimized is crucial. In this comprehensive guide, we’ll break down the intricacies of Snowflake’s billing model