Retool require's a connection string of the following format:
Whoever set up your Elasticsearch instance should be able to provide you with these parameters.
Make sure that your Elasticsearch user has at least read privileges as well as cluster monitoring privileges!
Create a new resource in Retool, and select "Elasticsearch" as the type. Enter a label by which you want to refer to this Elasticsearch integration. Enter the connection string obtained from the previous step, and click "Save".
Resources > Add > Elasticsearch
You can now select your newly-created Elasticsearch resource from the Resource dropdown when creating queries in your Retool apps.
You can display the results of Elasticsearch queries as with any other query in Retool. Note that the actual data is nested 2 levels inside the
data key, so instead of accessing it using
esQuery.data, you instead need to use