0 votes
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
asked by anonymous

1 Answer

0 votes
Hi,

SQL in DSS uses JDBC connections, so it is similar to making a client call from SQL IDE
answered by
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.
686 questions
705 answers
528 comments
434 users