Elasticsearch

This quickstart describes how to create an Elasticsearch connection.

Create a connection to Elasticsearch

Before you can write your transformed data to Elasticsearch, you should first establish a connection to your Elasticsearch database.

Your connection is persistent, so you won't need to re-create it for every job. The connection is also shared with other users in your organization.

Here’s the code for creating a connection to Elasticsearch:

// Syntax
CREATE ELASTICSEARCH CONNECTION <connection_identifier>
    CONNECTION_STRING = '<connection_string>' 
    USER_NAME = '<user_name>'
    PASSWORD = '<password>';

// Example
CREATE ELASTICSEARCH CONNECTION my_elasticsearch
    CONNECTION_STRING = 'elasticsearch://search-elastic1-tiq6hb7ltwvcu2vwp3tbixyzey.us-east-1.es.amazonaws.com:443?cluster.name=elastic_main&ssl=true'
    USER_NAME = 'your_user'
    PASSWORD = 'your_password';

After you complete this step, you should see the my_elasticsearch_connection connection in your navigation tree.

---

Learn more

Please see the SQL command reference for Elasticsearch for the full list of connection options, and examples.