passren opened a new issue, #36844: URL: https://github.com/apache/superset/issues/36844
*Please make sure you are familiar with the SIP process documented* [here](https://github.com/apache/superset/issues/5602). The SIP will be numbered by a committer upon acceptance. ## [SIP] Support SQL-based querying on MongoDB.<title> ### Motivation Apache Superset provides a rich SQL-based analytical experience, but it currently lacks a connector for NoSQL databases such as MongoDB. Providing SQL-based querying support for MongoDB would significantly improve Superset’s usability, lower the learning curve for analysts, and enable more real-time analytics directly on MongoDB data. ### Proposed Change I have created a DB API 2.0–compliant project that allows users to query MongoDB using SQL. A SQLAlchemy dialect has already been implemented in the project. The remaining work is to add MongoDB as a new engine in db_engine_specs, and to complete the unit tests and documentation. Project space: [https://github.com/passren/PyMongoSQL](https://github.com/passren/PyMongoSQL) The proposed connection string would be: `mongodb+superset://<user>:<password>@<host>:<port>/<database>` ### New or Changed Public Interfaces No changes to Public Interfaces ### New dependencies PyMongoSQL is required as a dependency and is maintained by me. I am also the author of [PyDynamoDB](https://github.com/passren/PyDynamoDB), which follows a similar design and maintenance model. The license is MIT. `pip install pymongosql` ### Migration Plan and Compatibility No migration is required. PyMongoSQL supports both SQLAlchemy 1.x and 2.x. ### Rejected Alternatives No -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
