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 https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html.

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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.