Apache Druid is a high performance real-time analytics database.
Installation
Required packages: pydruid
Connection String
druid://{username}:{password}@{host}:{port}/druid/v2/sql| Parameter | Description |
|---|---|
| username | Database username |
| password | Database password |
| host | IP address or URL of the host |
| port | Default 9088 |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 47/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
Compatible Databases
The following databases are compatible with the Apache Druid driver:
ImplyImply is a fully-managed cloud platform and enterprise distribution built on Apache Druid. It provides real-time analytics with enterprise security and support.
druid://{username}:{password}@{host}/druid/v2/sqlNotes
A native Druid connector ships with Superset (behind DRUID_IS_ACTIVE flag) but SQLAlchemy connector via pydruid is preferred.