Im a BI analyst, new to mongodb. Currently using Mongo Connector For Bi in order to connect my MongoDB to Tableau. Im trying to learn how SQL queries can be expressed in the MongoDB aggregation language by using 'mongotranslate' command, but it seems the CMD can't find this function. What i have tried:
mongotranslate “select * from groceries.fruits where _id >100;”\ --schema schema.drdl
Then i got:
mongotranslate is not recognized as an internal or external command
Is someone here familiar with mongodrdl? i'd appreciate the help