SQL Recipe validation failed : query does not return results

[jlbellier]

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.

[AlexT · Accepted solution]

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,

[jlbellier]

Hello AlexT,

It works much better with SQL Script recipe. Thanks a lot for the explanation.

Have a good day. 

Best regards,
Jean-Luc.