AWS DocumentDB Schemas Fail to refresh

Support Self Hosted Redash Support
,
1

Issue Summary

DocumentDB datasource failed when refreshing schemas (showing collections in database).

The error shown is “Schema refresh failed”

I tried to follow another post suggestion by changing the call $natural to _id in query_runner/mongo.py but no luck with that. The error persists.

Screen Shot 2021-06-29 at 11.30.28
Screen Shot 2021-06-29 at 11.30.281802×895 45.8 KB

A summary of the issue and the browser/OS environment in which it occurs.

Technical details:

  • Redash Version: redash/redash:10.0.0-beta.b49597 (Also happens in 8-9)
  • Browser/OS: Chrome
  • How did you install Redash: docker
2

I’d probably focus on forking this data source completely and implementing the desired schema fetch behaviour.

DocumentDB only works in Redash because it supports the same API as MongoDB. Schema refresh still works when connecting to MongoDB in Redash – so the issue here is a difference between DocumentDB and Mongo.