How to display DB queries made by DSS ?

Options
UserBird
UserBird Dataiker, Alpha Tester Posts: 535 Dataiker
Hi,

How can I see the actual queries made by DSS to my MongoDB (or any other database) connection ?

This would be helpful when optimizing our databases.



Thanks !

Answers

  • Clément_Stenac
    Clément_Stenac Dataiker, Dataiku DSS Core Designer, Registered Posts: 753 Dataiker
    Options
    * For visual recipes, you can go to Output > View query when the recipe executes in-database or in-Hadoop

    * For queries run as part of any job, you'll find the query in the logs (whether it's a query dataset, a visual recipe or a query recipe)



    Note that on the specific case of MongoDB, DSS has no in-database processing capabilities, so will never do queries other than:

    * iterate all collection
    * iterate all collection with filter on partitioning column
    * list distinct values of the partitioning column
Setup Info
    Tags
      Help me…