Make sure our schema allows for SQL joins across indices

[jzonthemtn]

Make sure our schema allows for SQL joins across indices.

[jzonthemtn]

We need to look at the initial list of desired reporting charts/graphs and ensure that our schemas can support the queries to power those visualizations.

[epugh]

What's teh best way to tackle this? We have both a miro board of potential reporting needs, plus some feedback from Stavros... Should we create a ticket for each one and try and get more explicit on what data is needed for each one?

[jzonthemtn]

We should mock up what each chart would look like and then try creating each one in OpenSearch Dashboards.

[RasonJ]

Reported the bug here: opensearch-project/sql#2550