Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

SQL Recipe validation failed : query does not return results

Solved!
jlbellier
Level 3
SQL Recipe validation failed : query does not return results

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.

0 Kudos
1 Solution
AlexT
Dataiker

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,

View solution in original post

0 Kudos
2 Replies
AlexT
Dataiker

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,

0 Kudos
jlbellier
Level 3
Author

Hello AlexT,

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

Have a good day. 

Best regards,
Jean-Luc.

0 Kudos