Force push down where clause

1

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

2

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

3

Hi ,

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

Gorka