Im a bi analyst, new to working with MongoDb’s. I’m using Mongo connector for bi (mongodrdl) to connect my DB to Tableau, and wanted to learn how can i aggregate my data in the schema file. I’ve tried using mongotranslate, but i cant find it’s location. i get the error “mongotranslate is not recognized as an internal or external command”.
my command was:
mongotranslate “select * from groceries.fruits where _id >100;”\ --schema schema.drdl
Is any one here familiar with Mongo connector for bi? please help