Use join in filters for dashboards

OpenSearch Dashboards
,
1

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

OpenSearch Playground,
OpenSearch Service in AWS,
Chrome last version

Describe the issue:

Hi!,

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?

Thanks!

Configuration:

Relevant Logs or Screenshots:

2

Hi @ijmarrero,

Have you had a chance to check this:

best,
Mantas

3

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

image
image1920×1080 223 KB

4

Hi @ijmarrero,

I do not believe this use case is supported, however, please check Notebooks to see if that would cover your use case: Notebooks - OpenSearch documentation

There are more details on OpenSearch Dashboards Notebooks here as well: Feature Deep Dive: OpenSearch Dashboards Notebooks · OpenSearch

Best,
Mantas