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.
Last updated