TLDR Tech / Data
Pushdown Optimization: Don't Take It for Granted
Snowflake and Databricks can place equivalent deterministic filters at very different stages, so predicate pushdown should be verified in execution plans rather than assumed.
Read the full story