Query history

You can use the information available through this screen to help you debug issues with queries.

This section describes how to work with query history using the UI. To work with query history using the API, see [Query History](https://docs.databricks.com/api/azure/workspace/query history).

View query history

To view previous runs for a query:

1. Click Query History in the sidebar.
2. Optionally, use the filters near the top of the page to filter the list by user, date range, compute, duration, query status, statement type, and statement ID.

For Databricks SQL queries, non-admin users without at least CAN MONITOR permissions can only view their own queries in Query History.

View query details

To view details about a query, such as the complete query statement, query source, duration, number of rows returned, and I/O performance, or execution details.

1. View query history.

2. Click the name of a query.

   

   • Statement ID: This is the universally unique identifier (UUID) associated with the given query object.
   • Query status: The query is tagged with its current status: Queued, Running, Finished, Failed, or Cancelled.
   • Compute type: This field shows the compute type used for the query.
   • Query statement: This section includes the complete query statement. If the query is too long to be shown in the preview, click the Expand query icon to see the full text.
   • Query source: This field shows where the query originated. Queries can come from a variety of sources, including AI/BI dashboards, query objects, the Databricks SQL editor, notebooks, and Delta Live Tables pipelines (Public Preview).
   • Wall-clock duration: Shows the elapsed wall-clock time between the start of scheduling and the end of query execution. The total is automatically displayed as the sum of scheduling time and running time. To learn more, each of those fields can be expanded into sub-categories.
   • Summary details: The bottom of the panel includes summary details about the query's performance, including aggregated task time, rows read and returned, files and partitions, and any spilling that might have occurred.

3. For more detailed information about the query's performance, including its execution plan, click View Query Profile near the bottom of the page. For more details, see Query profile.

Terminate an executing query

To terminate a long-running query started by you or another user:

1. View query history.

2. Click the name of a query.

3. Next to Status, click Cancel.

   Note

   Cancel only appears when a query is running.

The query is terminated, and its status changes to Canceled.