Where are SQL queries interpreted for custom recipes?

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
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

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer Posts: 753 Dataiker
    Options
    Hi,

    SQL in DSS uses JDBC connections, so it is similar to making a client call from SQL IDE
  • UserBird
    UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
    Options
    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.
Setup Info
    Tags
      Help me…