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

Aray

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

Alexandru

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.