ElasticSearch Connection¶

The ElasticSearch connection that enables ElasticSearch integrations.

Authenticating to ElasticSearch¶

Authenticate with the ElasticSearch DBAPI

Default Connection IDs¶

Some hooks and operators related to ElasticSearch use elasticsearch_default by default.

Configuring the Connection¶

User

Specify the login used for the initial connection

Password

Specify the Elasticsearch API key used for the initial connection

Host

Specify the Elasticsearch host used for the initial connection

Port

Specify the Elasticsearch port for the initial connection

Scheme

Specify the schema for the Elasticsearch API. http by default

Extra (Optional)

Specify the extra parameters (as json dictionary) that can be used in Elasticsearch connection. The following parameters are all optional:

http_compress: specify whether or not to use http_compress. False by default.
timeout: specify the time frame of the timeout. False by default.

When specifying the connection in environment variable you should specify it using URI syntax.

Note that all components of the URI should be URL-encoded.

For example:

export AIRFLOW_CONN_ELASTICSEARCH_DEFAULT='elasticsearch://elasticsearchlogin:elasticsearchpassword@elastic.co:80/http'

tests/system/elasticsearch/example_elasticsearch_query.py[source]

es = ElasticsearchSQLHook(elasticsearch_conn_id=CONN_ID)

es_connection = es.get_conn()
response = es_connection.execute_sql("SHOW TABLES")
for row in response["rows"]:
    print(f"row: {row}")
return True