You now have until September 15th to submit your use case or success story to the 2022 Dataiku Frontrunner Awards!ENTER YOUR SUBMISSION

update an existing column without creating a new dataset in flow recipe.

Aray
Level 1
Level 1
update an existing column without creating a new dataset in flow recipe.

Hi Team, 

What I am trying to accomplish is to run a couple of column updates in a PostgreSQL after receiving new data,  however, every time I try to use a new recipe, it's trying to create a new dataset(table) in the destination DB. Is there a way to create a flow recipe that only runs updates to an existing dataset without trying to create a new dataset?

thanks 

0 Kudos
1 Reply
AlexT
Dataiker
Dataiker

Hi @Aray,

What changes are you looking to perform? Are you looking at doing SQL recipe or Python?

You can create a python recipe with dummy output e.g a folder(where you will not be writing anything) and read the input dataset and modify it in the code.

You can also use Python Steps or SQL steps in a scenario as well. 

0 Kudos