Vidhi_Khaitan
Databricks Employee
Databricks Employee

This happens because Databricks' Delta Sharing client performs a two-phase query planning process:
First request sent without predicateHints or limitHints and its goal is to fetch the basic metadata -> the schema, partitioning info, statistics, etc.
Second request (actual query planning) is sent with predicateHints and limitHints and the actual data access request, incorporating pruning logic and filters.

Thus, ideally we should not ignore the first request.