10. Query History

10.1 What is the Azure Databricks Query History?

The query history shows SQL queries performed using SQL warehouses. The query history shows those queries that have been run within the past 30 days.

10.2 Practical

The Query history shows more than just the name of the query. It also shows the duration of the query and if you click the dropdown arrow next to the query, it will show the entire SQL query (as interpreted by Databricks rather than how you wrote it).

Clicking on the same interface shows more details about the SQL query.

Use the top query filters to narrow down your query history search in terms of time, compute, duration, status and statement.

For example, here we filter for those queries that had a running duration of greater than 1000 milliseconds.