Dremio pushdown not working correctly?

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?

@spireite Can you please send the job profile?