Where are SQL queries interpreted for custom recipes?

UserBird
Dataiker
Where are SQL queries interpreted for custom recipes?
I have a query that takes in a file path as parameter. The file is in a managed folder of Dataiku and the path has been verified to be correct. Proper permissions have also been set for the file. Is calling an SQL query from dataiku similar to making a client call from SQL IDE's or is it more similar to logging into the server machine and the making an SQL query there.



Many thanks for your response
0 Kudos
2 Replies
Clรฉment_Stenac
Hi,

SQL in DSS uses JDBC connections, so it is similar to making a client call from SQL IDE
0 Kudos
UserBird
Dataiker
Author
Thanks for the prompt reply, Clรฉment! I have some more questions, though.

Correct me if I am wrong that the SQL query, made from executor.query_to_df, from a Python plugin is streamed to a DSS engine which is within the machine where Dataiku is installed. This engine is the one that transfers the query to the database server connected via JDBC. If correct, how do I log on to this DSS engine.?This is so I can check if I have access to a file in a managed folder from the DSS engine. Thank you.
0 Kudos

Labels

?
Labels (5)
A banner prompting to get Dataiku