OpenSearch (OpenDistro)

https://opensearch.org/

OpenSearch (formerly OpenDistro for Elasticsearch) is an open-source, distributed search and analytics suite.

Installation

Required packages: elasticsearch-dbapi

Connection String

odelasticsearch+https://{user}:{password}@{host}:{port}/

Parameter	Description
user	OpenSearch username
password	OpenSearch password
host	OpenSearch host
port	Default 9200 (or 443 for managed services with HTTPS)

Default port: 9200

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

Official Documentation

SQLAlchemy Dialect Documentation

Help improve this documentation by editing the engine spec:

Edit elasticsearch.py