delete vs drop

Shahbaz
Shahbaz Registered Posts: 2
edited 6:45AM in Using Dataiku

Hi, currently I am working on a project which I have to collect data but it should be new and have the same schema with previous one but without keeping the past data how can I do this?
Firstly, I thought that delete option will work for me but at the end, it didn't do what I am looking for;
Thanks in advance

Operating system used: windows

Operating system used: windows

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,090 Neuron

    I am not really sure what you are asking here. Dataiku loads new data and doesn't keep historical data by default, you don't have to do anything special to load new data. In fact for every recipe output that's stored in a SQL database Dataiku will issue a drop statement before loading the data (unless the Append instead of overwrite option is selected).

Setup Info
    Tags
      Help me…