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.