Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
Hi Bryan, Depending on the information you want to retrieve, you can write queries and showcase that in a dashboard. Please see these links for sample query and dashboard.
That did not address the requirement to show the saved/pre-defined queries in our own dashboard, while the saved/pre-defined queries cannot be identified from system.query.history
Hi Bryan, As I mentioned in the previous thread, query history doesn't store saved query information. There is no out of the box feature which can showcase saved query in the dashboard. For accessing saved query you can follow these methods.
Workspace UI: You can view and manage saved queries by clicking on "Workspace" or "Queries" in the sidebar.
Workspace Browser: Queries can be organized into folders along with other Databricks objects in the workspace browser.
API and Connectors: You can create and manage queries using the REST API, JDBC/ODBC connectors, or partner tools without using the Databricks UI.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.