Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello everybody,
I am stuck because my SQL recipe failed at validation process and DSS tells : Query does not return, resuls. I have just modified an exsting SQL recipe to adapt it for my case
It is an insert query. I have just run the query on postgreSQL and the rows were inserted.
What could be the source of the problem ?
Thank you in advance for your help.
Best regards,
Jean-Luc.
Hi @jlbellier ,
Could you try using SQL Script Recipe instead?
This should allow you to handle inserts yourself.
For SQL script recipe DSS directly submit your query to the database.
For SQL Query Recipe, DSS expects results to be returned by the query and DSS will handle the insert.
https://doc.dataiku.com/dss/latest/code_recipes/sql.html
Thanks,
Hi @jlbellier ,
Could you try using SQL Script Recipe instead?
This should allow you to handle inserts yourself.
For SQL script recipe DSS directly submit your query to the database.
For SQL Query Recipe, DSS expects results to be returned by the query and DSS will handle the insert.
https://doc.dataiku.com/dss/latest/code_recipes/sql.html
Thanks,
Hello AlexT,
It works much better with SQL Script recipe. Thanks a lot for the explanation.
Have a good day.
Best regards,
Jean-Luc.