'Append instead of overwrite' does not append table after recipe

Options
pkusuma
pkusuma Registered Posts: 2 ✭✭✭✭
Hi,

I am trying to use the functionality 'Append instead of overwrite' to store an output after writing a recipe. However, I don't see the results being appended to the table. Instead, Dataiku performs truncate table and then invokes insert table command.

When I use sync functionality, 'Append instead of overwrite' works. New rows are always added to the table.

Is this a bug within Dataiku?

P
Tagged:

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    Hi,

    What is the kind of recipe and kind of output that you are trying to append to ?
  • pkusuma
    pkusuma Registered Posts: 2 ✭✭✭✭
    Options
    Hi,

    The flow is as follows:
    Input is a dataset via a file upload. Then, it connects to a 'prepare' recipe, which performs column renaming and deleting. Then the result of this prepare recipe is supposed to be appended to an Oracle database.

    When I only use 'sync', the result is successfully appended to the table.
  • kevmcclosk
    kevmcclosk Registered Posts: 5 ✭✭✭
    Options

    I'm experiencing the same thing and am interested in a solution.

Setup Info
    Tags
      Help me…