Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

How to display DB queries made by DSS ?

Dataiker
Dataiker
How to display DB queries made by DSS ?
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 !
0 Kudos
1 Reply
Dataiker
Dataiker
* 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
0 Kudos
Labels (2)