Survey banner
The Dataiku Community is moving to a new home! New posts are now disabled and the community will shortly be in temporary read only mode: LEARN MORE

How to display DB queries made by DSS ?

How to display DB queries made by DSS ?

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
* 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