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

Juan Carlos
Juan Carlos Partner, Dataiku DSS Core Designer, Registered Posts: 1 Partner

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

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 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.

Setup Info
    Tags
      Help me…