How to display DB queries made by DSS ?

UserBird

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 !

Clément_Stenac

* 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