sql Save sql query as visualization

Is your feature request related to a problem? Please describe.

Since we can write sql query in Query Workbench, and get the result immediately. But we have to paste the sql statement everytime and could not use the result to draw a visualization report.

Describe the solution you'd like

Save the sql query as a type of visualization, so we don't need to save the sql out of opensearch and treat it the same as DQL

Describe alternatives you've considered

Apr 04 '22 15:04 anic

Hello @anic!

Thanks for opening! I agree! Will re-route to the SQL plugin repo, but perhaps they can store this query into the system index that OpenSearch Dashboards uses.

Apr 05 '22 03:04 kavilla

@kavilla @anic Is it currently possible to use SQL query result data for visualisations? Say I want to create a new document with fields derived from the SQL query result. I can see this can kind of be done within a Notebook but I have to select already created visuals..

Jun 14 '22 04:06 BT-93