All Collections
Logs Management
Querying Opensearch Dashboards using the SQL Workbench
Querying Opensearch Dashboards using the SQL Workbench

Find out how you can query Opensearch Dashboards using familiar SQL syntax in this informative help article from

Kieran Southern avatar
Written by Kieran Southern
Updated over a week ago

Opensearch Dashboards SQL Workbench Introduction

Opensearch Dashboards SQL Workbench gives you the ability to query data from Opensearch much easier when compared to standard DSL, test your findings before saving and quickly convert familiar SQL syntax into its REST equivalent where required.

If you are already familiar with making Opensearch queries using SQL then the SQL Workbench will be a welcome addition to your Opensearch Stack workflow.

Tip: Opensearch Dashboards security roles requires a Stack running Opendistro 1.13 onwards

Kibana Query Workbench overview

To get started, launch Opensearch Dashboards from your dashboard and choose Query Workbench from the left menu.

Exporting query data

In the event that you are more comfortable with seeing your query as a tabbed format or wish to export this as a CSV, JDBC or JSON file this is also possible thanks to this convenient interface.

Export Kibana query data

Building queries using Typeahead

By starting to type a term you see typeahead suggestions to assist with building your query. The typeahead is based on your data model and so makes building queries much simpler.

Query workbench editor

Converting SQL into Opensearch JSON

By taking advantage of the Explain functionality you can easily convert your SQL queries into Opensearch JSON queries which would normally take considerable time and effort. To translate a SQL statement into valid Opensearch JSON from the Query Builder, add your valid SQL query and then choose Explain.

How to convert SQL into Elasticsearch JSON

What’s Next?

Did this answer your question?