{"repo":"preset-io/elasticsearch-dbapi","free":true,"listed":false,"github":"https://github.com/preset-io/elasticsearch-dbapi","clone":"git clone https://github.com/preset-io/elasticsearch-dbapi.git","description":"A DBAPI and SQLAlchemy dialect for Elasticsearch","language":"Python","stars":120,"topics":["sqlalchemy","elasticsearch"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"ElasticSearch DBAPI elasticsearch-dbapi Implements a DBAPI (PEP-249) and SQLAlchemy dialect, that enables SQL access on elasticsearch clusters for query only access. On Elastic Elasticsearch: Uses Elastic X-Pack SQL API On OpenSearch (AWS ES): OpenSearch SQL This library supports Elasticsearch 7.x, Elasticsearch 8.x (via compatibility mode), and OpenSearch 2.x. Note: To connect to Elasticsearch 8.x, set the environment variable ELASTIC CLIENT APIVERSIONING=1 on your Python application (not on Elasticsearch itself). This enables the elasticsearch-py client compatibility mode. Installation To install support for AWS Elasticsearch Service / Open Distro: Usage: Using DBAPI: Using SQLAlchemy execute: Using SQLAlchemy: Using SQLAlchemy reflection: Connection Parameters: elasticsearch-py is used to establish connections and transport, this is the official elastic python library. Elasticsearch constructor accepts multiple optional parameters that can be used to properly configure your connection on aspects like security, performance and high availability. These optional parameters can be set at the connection string, for example: will set transport to use gzip (http compress) and timeout to 10 seconds. For more information on configuration options, look at elasticsearch-py ’s documentation: - Transport Options - HTTP tranport The connection string follows RFC-1738, to support multiple nodes you should use sniff parameters Fetch size By default the maximum number of rows which get fet","default_branch":null,"files":null,"tree":[],"storefront":"/r/preset-io","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/preset-io/elasticsearch-dbapi/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}