Use join in filters for dashboards

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

OpenSearch Playground,
OpenSearch Service in AWS,
Chrome last version

Describe the issue:


We need to do joins and aggegations before visualize results in a dashboard. We cannot rely on batch processing and It seems that only DSL is available as a way to filter data.

Could we use SQL sentences (OpenSearch dialect), join-like capabilities in DSL o PPL?



Relevant Logs or Screenshots:

Hi @ijmarrero,

Have you had a chance to check this:


Hi @Mantas
Yes, but I cannot include things like

  "query": "SELECT * FROM my-index LIMIT 50"

in the “filter” section of my dashboards. See attached screenshot of plaground