Elasticsearch is a distributed search and analytics engine. Query data using Elasticsearch SQL or OpenSearch SQL syntax.
Installation
Required packages: elasticsearch-dbapi
Drivers
Elasticsearch SQL API (Recommended)Recommended
OpenDistro / OpenSearch SQL
PyPI Package:
elasticsearch-dbapielasticsearch+https://{user}:{password}@{host}:9243/For Elastic Cloud and self-hosted Elasticsearch with SQL enabled.
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 37/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 Elasticsearch driver:
Elastic CloudElastic Cloud is the official managed Elasticsearch service from Elastic. It includes Elasticsearch, Kibana, and enterprise features with automatic scaling.
elasticsearch+https://{user}:{password}@{deployment}.{region}.cloud.es.io:9243/Amazon OpenSearch Service (successor to Amazon Elasticsearch Service) is a managed search and analytics service on AWS.
odelasticsearch+https://{user}:{password}@{host}:443/Help improve this documentation by editing the engine spec: