AWS DocumentDB Schemas Fail to refresh

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.

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

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.