Using the new SQL integration

Elasticsearch SQL was a feature that was introduced in version 6.3, and allows users to query Elasticsearch with SQL queries.

The API is available through the X-Pack API to query an index, like the one shown in the following example:

POST /_xpack/sql?format=txt 
    "query": "SELECT * FROM my_index WHERE release_date < '2000-01-01'" 
If you want more details on this API, check out the documentation at

To switch and use Elasticsearch SQL as the preferred data source, simply click on the Data button when your data table is selected and choose Change your data source. Then, pick Elasticsearch SQL. In the text area, you can paste any Elasticsearch ...

Get Machine Learning with the Elastic Stack now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.