Python + SQL

Elastic Stack Elasticsearch
1

Hi there!

I was about to rewrite all the functions that I have in DSL to the new SQL functionality for testing and learning purposes. Once I got into it, I wasn't able to find any functionality to query using SQL and Python in the Python API documentation. Anyone has any information about it?

Thanks in advance :smiley:

2

Hi,

as SQL is an X-Pack feature this would need to be part of the X-Pack APIs but at the moment this is not supported. This is probably because SQL is currently experimental. However, to experiment with the API you could use the raw transport API and issue the SQL API calls yourself.

Daniel