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.
Greybeam's multi-query-engine dream is slowly becoming a reality. Lately, we've been encountering more and more data teams who are looking to offload non-critical workloads to alternative compute engines like