Connecting to Elasticsearch
Elasticsearch is a highly-scalable cloud database provided by Amazon Web Services. In this article, we'll show you the steps for connecting to Elasticsearch and how to use it within Qrvey.
Once inside your desired application, select Datasets from the slide-out menu on the left, then click the orange Add Dataset button to create a new data source.
Next, choose Elasticsearch from the list of data source options and click Continue.
Enter your Elasticsearch Connection String into the box provided, then click Test. If successful, you will then be able to click Next and choose your data index.
On the Select Index page, you'll be able to see and choose the index you'd like to connect, along with the current health of those indices. Make your selection and click Next.
Finally, you may select which columns you'd like to connect by using the checkboxes in the left-hand column. A search box is provided for datasets with large numbers of columns. Qrvey will automatically profile your data and choose an appropriate data type, but you can further refine how you'd like each column to appear in Qrvey by updating the data types as needed. To learn more about the available data types, just look on the right side of the window.
If your data contains address information, you may choose to create a Geolocation Group by setting geolocation as a data type for one column, then letting Qrvey know where to find the remainder of the information as seen below. Once your group has a name and all of its fields defined, you may save your group and continue.
When you are happy with your selections, click Save in the upper right corner and your new dataset will be imported. Please note that it may take some time for all of your data to be loaded depending on the size of your data.
Deleting an Elasticsearch Dataset
To delete an Elasticsearch dataset, just navigate to Datasets inside your application and select Delete from the three-dot menu on the right side of the dataset as seen below.