topic Re: Can I publish the query stored in the "Query History"? in Generative AI

Can I publish the query stored in the "Query History"?

mimsalar — Tue, 17 Mar 2026 15:55:58 GMT

I’m using an agent within a Databricks app that converts plain English into SQL, executes the query against a warehouse table, and returns the results.

I’d like to know if there’s a way to also surface or publish the generated SQL query within the app. I can see the query in the Query History, but I haven’t found a way to expose it directly in the app interface.

Re: Can I publish the query stored in the "Query History"?

balajij8 — Tue, 17 Mar 2026 16:23:05 GMT

You can use the SQL string generated by agent handling the English - SQL conversion using code & display it along with results in the web app
Query the system query history table with statement ID for statement_text (system.query.history) & display the executed query in the web app if issues in finding the query generated by agent

More details here

Re: Can I publish the query stored in the "Query History"?

MoJaMa — Wed, 18 Mar 2026 02:07:31 GMT

You may have to add a call to the Query History API with the necessary filter_by.

https://docs.databricks.com/api/workspace/queryhistory/list