Spark's Advanced Query Pushdown feature automatically ensures that all possible filters and aggregations are performed on the underlying warehouse instead of being performed in-memory.

In [PR#572](https://github.com/snowflakedb/spark-snowflake/pull/572), Snowflake has removed this feature in their spark connector without any real explanation.