MongoDB

https://www.mongodb.com/

MongoDB is a document-oriented, operational NoSQL database.

Installation

Required packages: pymongosql

Drivers

MongoDB Atlas CloudRecommended

MongoDB Cluster

PyPI Package: pymongosql

mongodb+srv://{username}:{password}@{host}/{database}?mode=superset

For MongoDB Atlas cloud service.

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 32/201

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Extended Time Grains:

FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR

Notes

Uses PartiQL for SQL queries. Requires mode=superset parameter.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit superset.db_engine_specs.mongodb.py