> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hightouch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Elasticsearch

> Query Elasticsearch with SQL and sync the results to any Hightouch destination.

## Overview

Hightouch lets you pull data stored in Elasticsearch using [Elasticsearch SQL](https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html) and push it to downstream destinations. Most of the setup occurs in the Hightouch UI, but you need access to Elasticsearch for information like your host, port, and credentials.

> [!NOTE]
>
> You may need to allowlist Hightouch's IP addresses to let our systems connect to your warehouse. Reference our [networking docs](https://docs.hightouch.com/security/networking#ip-addresses) to determine which IP addresses you need to allowlist.

## Connection configuration

Hightouch supports connecting to your Elasticsearch clusters via optional [basic authentication](https://www.elastic.co/guide/en/elasticsearch/reference/current/http-clients.html).

To get started, go to the [**Sources** overview page](https://app.hightouch.com/sources?from=docs) and click the **Add source** button. Select **Elasticsearch** and enter the following fields into Hightouch:

* **Host**: The hostname or IP address of your Elasticsearch server.
* **Port**: The port number of your Elasticsearch server's HTTP API. The default is 9200, but yours may be different.
* **Username**: This can be your personal Elasticsearch login or a dedicated user for Hightouch.
* **Password**: The password for the user specified above.

## Test your connection

When setting up Elasticsearch as a source for the first time, Hightouch checks that you have the correct permissions. Once the test passes, click **Continue** to finish setup.

## Create models

Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up [models](https://docs.hightouch.com/getting-started/concepts.md#models) to define which data you want to pull from Elasticsearch.

The Elasticsearch source support writing queries in [the SQL editor](https://docs.hightouch.com/models/sql-editor.md) as its modeling method.

## Tips and troubleshooting

If you run into an issue this page doesn't cover, [contact support](#pylon-chat).