Benchmarking Snowflake Interactive Tables and Warehouses
Are interactive tables worth it? What are the caveats? We answer all of that and more.
Optimization
How Headset Cut Snowflake BI Costs by 83% While Supporting 2,500+ Users
Headset's journey to drastically reduce Snowflake costs from ingestion to analytics.
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.
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