New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

How to display DB queries made by DSS ?

UserBird
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
Clément_Stenac
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)
A banner prompting to get Dataiku DSS