Snowflake - Build and Architect Data Pipelines Using AWS - What Is Pushdown in UDF?

The video tutorial explains the concept of pushdown in data processing, particularly in Snowflake. It describes two methods of query execution: 'load first, filter later' and 'early filtering', with the latter being more efficient. Pushdown improves query performance by filtering data early, reducing memory usage. However, it may expose confidential data if not managed properly. Snowflake automatically optimizes pushdown execution using its query planner.

Describe how Snowflake's query planner handles pushdown execution.

What are the potential downsides of using pushdown in query execution?