SQL

The easiest way to get familiar with the SQL plugin is to use Query Workbench in OpenSearch Dashboards to test various queries. To learn more, see Workbench.

Here’s how core SQL concepts map to OpenSearch:

You can query multiple indices by listing them or using wildcards:

By default, queries return data in JDBC format, but you can also return data in standard OpenSearch JSON, CSV, or raw formats:

See the rest of this guide for detailed information on request parameters, settings, supported operations, tools, and more.