Redash: MongoDb schema refresh failed if system.views are present

[aguarino77]

Issue Summary

When creating a query on a MongoDb data source, schema refresh fails if views are present in the database. Even dbAdmin roles on the user defined in the connection string is not enough to prevent the issue. If the db has no views, collections are shown.

Which is the right way (if any!!!) to define the user role needed to get the schema of the mongodb collections?

Steps to Reproduce

1. Create the monogdb source, test the connection string
2. Create a query

Technical details:

[mwvaughn]

I'm hitting the same issue with v5.0.0-beta as well as v4.0.1. Have you had any luck?

[aguarino77]

No, and this is really preventing us from using redash....

[hadifarnoud]

I have the same issue with mongodb data source. connection test reports success

[arikfr]

Fixed in #2961.

[AntonTsaberyaby]

Hi,

The same issue is still persists

Version: Redash 5.0.2+b5486

[jodevsa]

Hi @AntonTsaberyaby

The fix #2961 has not been released yet.
Until the next release is published you can pull redash/query_runner/mongodb.py from master and replace it with your current.

[AntonTsaberyaby]

@jodevsa Thanks!