Apply filter while reading from source connection
kogan
Registered Posts: 2 ✭
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?
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,141 Neuron
Use either a Filter or a Prepare recipe.
-
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.