I’ve found myself in a position where I submit a query to SQLServer, with a WHERE clause and pushdown - doesn’t.
Without the WHERE, the query would return 173m rows. With a WHERE clause, it should be 112 rows.
It appears that Dremio is submitting the SQL wthout the WHERE clause, and then Dremio filters ‘locally’.
Is that right?