-
Notifications
You must be signed in to change notification settings - Fork 12.9k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Does superset support integration with MongoDB? #4231
Comments
Feel free to contribute a mongodb sqlalchemy dialect. |
@priyankajuyal I think there're 3 methods to support mongodb in superset:
|
4th option: Use an SQL wrapper like https://dremio.com. (I am not related to this project or company, but happened to stumble upon it, recently) |
5th option: There is a tool called BI Connector from mongodb, this tool can map mongodb schemata to relational. It's used to interact e.g. with Tableau or other BI Tools. Unfortunately AFAIK it's only available in a paid mongodb version. https://www.mongodb.com/products/bi-connector |
@rumbin I don't think there's a Dremio connector for Superset though, have you seen one? |
I have created a MongoDB connector for Superset under the name of cosmos. It is still WIP. Feel free to check it out. Star it and post issues so that it can be developed further. https://github.com/ksangeet9ap/incubator-superset |
For Dremio, your best bet is probably https://github.com/sqggles/sqlalchemy_dremio |
@mistercrunch Any plans on integrating NoSQL databases to Superset? |
The real question is "Any plans for NoSQL databases to start supporting SQL?". ElasticSearch just added experimental SQL support, Druid added SQL a few years back. Apache Calcite makes that a lot easier now. Even though it's totally doable with Superset (check out the |
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. |
so , how may anyone use superset with MongoDB . |
|
Could you explain how I would implement this? |
Its available for free now. I would like to know if someone was able to connect through it |
I tried using the 1st option. It gives me driver not found error. I installed it in the same venv also. but still no luck. Did anyone got it working this way? |
Is there anybody using Superset and MongoDB? |
I just made a proof of concept of querying a mongo database with superset through mongo bi connector : https://github.com/jbouzekri/docker-superset-mongo-poc/. It seems to work pretty well. It is not in the documentation but I have tested row level security and it works too. |
@jbouzekri thank you for the POC! really appreciate your efforts. |
@jbouzekri thank you for the POC! But I ran into some problems using it: pulling the code locally and then executing the 'docker-compose up' directive encountered an error and terminated the directive. Could you give me some help? |
@Hugh-Guan : can you open an issue directly in the POC repository with the details of the error ? Thanks in advance |
@jbouzekri Thank you for your reply. I have put forward an issue in the project |
Have anyone tried integrating Superset with Azure Cosmos DB? It has a MongoDB API, I wonder if it works with sqlalchemy. |
I tried connecting using the following SQLAlchemy URI
mongodb://localhost:27017/test
and faced the following error:
ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nCan't load plugin: sqlalchemy.dialects:mongodb"}
Is there any workaround? Please suggest.
The text was updated successfully, but these errors were encountered: