Apply filter while reading from source connection

[kogan]

Hi,

I am new to dataiku, and explore tool capabilities.  Appreciate any help.

usecase:

I have a vertica database, while more than billion records from 2019, I want to apply filters on multiple column while reading data from source.  I have tried multiple way, but not able to do.  Any pointer on how to do?

[Turribeach]

Use either a Filter or a Prepare recipe. 

[kogan]

I tried filter recipe, but the filter is applied after data is read from the source.  I want to apply filter before data is read, without using custom sql query.