Elasticsearch

This article describes how to create a connection to Elasticsearch using a SQL command.

To write your transformed data into an Elasticsearch index using SQLake, you must first create a connection that provides the appropriate credentials to access your cluster.
CREATE ELASTICSEARCH CONNECTION my_elasticsearch
    CONNECTION_STRING = 'elasticsearch://host:port?cluster.name=your_cluster_name'
    USER_NAME = 'your_user'
    PASSWORD = 'your_password';
Connection options
CONNECTION_STRING — editable
Type: text
The connection string to use when connecting to the cluster.
Format:
'elasticsearch://host:port?cluster.name=your_cluster_name'
USER_NAME — editable with password
Type: text
The user to authenticate to the cluster.
PASSWORD — editable with user_name
Type: text
The password for the user.
COMMENT — editable
Type: text
(Optional) A description or comment regarding this connection.
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'
    COMMENT = 'My new Elasticsearch connection';

AWS Glue Data Catalog

Microsoft SQL Server

Last modified 14d ago

Elasticsearch

Connection options

`CONNECTION_STRING` — editable

`USER_NAME` — editable with `password`

`PASSWORD` — editable with `user_name`

`COMMENT` — editable

Example