Force push down where clause

Hi all,

I would like to know if there’s any tip or magic to force the push down of the where clause in a query when using sql server databases.

Thanks in advance,
Gorka

Hi @gesnal

Dremio should automatically push down if the “ARP” framework thinks that is the best. From 4.8 you can also use the External query feature to send any SQL (does not get parsed by Dremio) to SQL server. You can use SQL server only functions too

Detailed documentation here: External Query

Hi ,

this is exactly what we needed, thanks a lot for the help, really appreciated.

Gorka