@saurabhkumar
Free member
Learning Snowflake while contributing to open source around cost optimization.
A report filtering customers with total revenue over 10000 used WHERE instead of HAVING and just silently returned wrong numbers instead of erroring. That actually failed to parse in our case, so the real bug was different. We'd filtered on WHERE order_date >= without realizing it excluded rows the sum needed before grouping. How do people avoid this class of mistake?
© 2026 Lakebench, operated by Hunnurji Rao. Bengaluru, Karnataka, India.
No cluster. No install. Just the tab.
