This version of the OpenSearch documentation is no longer maintained. For the latest version, see the current documentation. For information about OpenSearch version maintenance, see Release Schedule and Maintenance Policy.

Discover

Discover is a tool for exploring your data in OpenSearch Dashboards. You can use Discover to visually represent your data on a dashboard and provide a high-level view of key metrics.

The following image represents a typical Discover page using sample data.

Discover start screen

Get started

In this tutorial, you’ll learn about using Discover to:

  • Add data.
  • Interpret and visualize data.
  • Share the data findings.
  • Set alerts.

Prerequisites

The following are prerequisites for using Discover:

Add data

Data must be added to OpenSearch before it can be analyzed. In this tutorial, you’ll use the sample data. To learn about importing your own data, see Managing indexes.

To add the sample data, follow these steps:

  1. On the OpenSearch Dashboards home page, choose Add sample data.
  2. Choose the desired sample data and select the Add data button. A screenshot of the Add sample data interface is shown in the following image.

Add sample data interface

To define a search, follow these steps:

  1. On the OpenSearch Dashboards navigation menu, select Discover.
  2. Choose the data you want to work with. In this case, choose opensearch_dashboards_sample_data_flights from the upper-left dropdown menu.
  3. Select the calendar icon (calendar icon) to change the time range of your search and then select Refresh.

You’ll see a view similar to the one in the following image.

Discover interface showing search of flight sample data for Last 7 days

Add data fields and view data details

The document table contains document data. Each row represents a single document, and each column contains a different document field representing metrics such as flight destination, average ticket price, and flight delay. You can add, delete, or modify data fields in a document table as needed to meet your data analysis requirements.

To add or delete fields in a document table, follow these steps:

  1. View the data fields listed under Available fields and select the plus icon (plus icon) to add the desired fields to the document table. The field will be automatically added to both Selected fields and the document table. For this example, choose the fields Carrier, AvgTicketPrice, and Dest.
  2. To arrange or sort the columns, select Sort fields > Pick fields to sort by and then drag and drop the fields in the order you want them to be ordered.

You’ll see a view similar to the one in the following image.

Discover interface showing adding and sorting data fields

You can view individual or multiple fields in the document table. To gather information about the data in the document table, follow these steps:

  1. From the data table’s left-side column, choose the inspect icon (inspect icon) to open the Document Details window. Select the minimize icon (minimize icon) to close the Document Details window.
  2. Review the data details. You can switch between the Table and JSON tabs to view the data in your preferred format.
  3. Select View surrounding documents to view data for other log entries either preceding or following your current document or select View single document to view a particular log entry.

You’ll see a view similar to the one in the following image.

Document details interface

Search the data

You can use the search toolbar or enter a DQL query using the DevTools console to search data. While the search toolbar is best for basic queries, such as field name queries, DQL is best for complex queries, such as term, string, Boolean, date, range, or nested queries. DQL provides suggestions for fields and operators as you type, helping you build structured queries.

To search data, follow these steps:

  1. Enter a simple query in the DQL search bar. For example, enter FlightDelay:true, which searches for delayed flights.
  2. Select the Update button to the right of the search bar.
  3. Enter a more complex query in the DQL search bar, and then select Update. For example, enter FlightDelay:true AND FlightDelayMin >= 60, which searches the data for flights delayed by 60 minutes or more.

Filter the data

Filters allow you to narrow the results of a query by specifying certain criteria. You can filter by field, value, or range. The Add filter pop-up suggests the available fields and operators.

To filter your data, follow these steps:

  1. Under the DQL search bar, choose Add filter.
  2. Select the desired options from the Field, Operator, and Value dropdown lists. For example, select Cancelled, is, and true.
  3. Choose Save.
  4. To remove the filter, choose the cross icon (cross icon) next to the filter name.
  5. Add more filters to further explore the data.

To save your search, including the query text, filters, and current data view, follow these steps:

  1. Select Save in the upper-right corner.
  2. Give the search a title, and then choose Save.
  3. Select Open to access the saved search.

Create data visualizations in Discover

To create visualizations of the data findings using the Discover app, follow these steps:

  1. Select the inspect icon (inspect icon) next to the field you want to visualize.

    You’ll see a view similar to the following image.

    Visualize data findings interface

  2. Select the Visualize button. The Visualize app opens and a visualization is displayed. Learn more about the Visualize app and data visualizations in Building data visualizations.

    You’ll see a view similar to the following image.

    Data visualization of flight sample data field destination

Set alerts

You can set alerts to notify you when your data changes beyond the thresholds you define. To learn more about using Discover to create and manage alerts, see Alerting dashboards and visualizations.