Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Appending dataset with python data frame in scenario

Level 1
Appending dataset with python data frame in scenario

Hi wrote this python code to store SQL dataset output in another SQL dataset using python only. "output_df" data frame is having 1 row but while appending into the data set it's now inserting and returning the message with "0 rows successfully written". 





I also put result of "output_df" data frame which I want to append into the "BENCHMARK_MR" dataset.


Operating system used: Windows

Operating system used: Windows

0 Kudos
1 Reply

Hi @Savan_Hipara,

That's odd, I haven't been able to reproduce the 0 rows successfully written message if my input dataset contains data. 

Would you be able to add a print statement immediately before your attempt to write out the data? 


Another thing you could try is to call write_dataframe() on output_dataset directly:


If you still see that no rows are written, can you grab the schema for both "output_df" and the output dataset?


client = dataiku.api_client()
project = client.get_default_project()
output_dataset = project.get_dataset('BENCHMARK_MR')

Thank you,


0 Kudos