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.
Kyle Cheung
Co-founder & CEO, Greybeam
optimization for you, you, you, you, and you
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.
Cut Costs by Querying Snowflake Tables in DuckDB with Apache Arrow
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
Querying Snowflake Managed Iceberg Tables with DuckDB
Welcome to part two in our series of working with Iceberg tables. If you haven't already setup your Snowflake managed Iceberg tables, be sure to check out part one in our
How to Get Started with Iceberg Tables in Snowflake
At Greybeam, we're constantly exploring ways to optimize Snowflake, and I'm so thrilled that our journey led us to Iceberg and DuckDB. In this post, we'll cover