Execution is failing using Jupyter notebook but works if it's executed as Python recipe

[ifotopoulos]

I have the following pipeline:

If I execute the python code using a Jupyter notebook view, I'm getting the following error in the final step that I write the results back to the Oracle DB:

Exception: An error occurred during dataset write (vJtTAiJlje): SQLSyntaxErrorException: ORA-01031: insufficient privileges

On the other hand If I save it back to recipe and execute it as a Python Recipe, everything works as expected. 

[Clément_Stenac]

It's difficult to say much without any details, but this looks like a fully Oracle-related issue. The error message you get is a purely Oracle message.

You can check into the "backend.log" file (Administration > Maintenance > Log files) which may contain additional information about what write exactly was attempted and why it failed.