Mongo Queries based on Views (Feature Request)

[BenHizak]

I would like to request queries based on saved queries (also called MongoDB Views ).

Benefits:

1. Give users the best of both worlds (Native Queries and Metabase Query builder). Each tool has it's own strength.

2. Enable future support for MongoDB (if metabase does not support something, it can be implemented at the view level). I am talking about such features as allowDiskUse: <boolean> and cursor: <document>.

3. Users will no longer have to tweak mongoDB queries (at present, users have to add double parentheses around operators (this is not supported by MongoDB, hence, this is a new 'query dialect')

4. This would also solve [MongoDB] - Filtering on empty date broken #4603

⬇️ Please click the 👍 reaction instead of leaving a +1 or update? comment

[thedavidprice]

Any updates on Views support since the update of Monger? Assuming still not working but curious if it's been attempted by anyone yet.

Update
My initial test seems to be working! I am able to query a Mongodb View using Metabase v0.31.2 and Mongodb v4.06 running on Atlas. I was not able to query this same View previously using Mongo v3 and Meta v0.29'ish.

[samuelbirocchi]

This feature is working properly, I think we can close this issue.

[flamber]

Closing, since createView works on MongoDB 4.0+ with Metabase (tested 0.41.1)