MonetDB is an open-source column-oriented relational database for high-performance analytics.
Installation
Required packages: sqlalchemy-monetdbpymonetdb
Connection String
monetdb://{username}:{password}@{host}:{port}/{database}| Parameter | Description |
|---|---|
| username | Database username (default: monetdb) |
| password | Database password (default: monetdb) |
| host | MonetDB server host |
| port | Default 50000 |
| database | Database name |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 26/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
Resources
Help improve this documentation by editing the engine spec: