MongoDB is a document-oriented, operational NoSQL database.
Installation
Required packages: pymongosql
Connection String
mongodb://{username}:{password}@{host}:{port}/{database}?mode=superset| Parameter | Description |
|---|---|
| username | Username for MongoDB |
| password | Password for MongoDB |
| host | MongoDB host |
| port | MongoDB port |
| database | Database name |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Notes
Uses PartiQL for SQL queries. Requires mode=superset parameter.
Resources