Add table visualization to PPL Observability dashboards

[saselvan]

Is your feature request related to a problem?
I'm frustrated that I cannot display PPL query results in a simple table visualization on OpenSearch Dashboards. While we can successfully run PPL queries to calculate averages, counts etc grouped by parsed fields, we can only visualize the results using charts (bar, pie, time series, etc.). The basic table view that's available in the query results page isn't available as a visualization option for dashboards.

What solution would you like?
Add a "Table Visualization" option for PPL queries in OpenSearch Dashboards that would allow displaying tabular data directly on dashboards, similar to the "Table View" available in the query results interface. This would enable users to show raw data and calculated fields in a simple, readable format.

What alternatives have you considered?
Using existing visualizations (bar charts, pie charts) and toggle the show table view option and then save the visualization but these don't display tabular data on the dashboard
Converting PPL queries to OpenSearch DQL to use existing table visualizations (if available) There are missing functions like parse and aggregations which make this a non-option.

Do you have any additional context?
PPL queries are increasingly important for data analysis in OpenSearch.
Table visualizations are a fundamental way to display data and are available in most other analytics platforms
This feature would bridge the gap between PPL's analytical capabilities and dashboard visualization options
The functionality already exists in the query interface's "Table View," suggesting the underlying capability is there