Elasticsearch

https://www.elastic.co/elasticsearch/

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-dbapi

elasticsearch+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

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Compatible Databases

The following databases are compatible with the Elasticsearch driver:

Elastic Cloud

Elastic 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

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:

Edit elasticsearch.py