Databricks provides several ways to access and manage your query history:

1. Query History UI

• Location: Click “Query History” in the sidebar of your Databricks workspace.
  • Features: View a list of executed SQL queries.
  • Sort by duration, start time, or other criteria.
  • Filter by user, date range, SQL warehouse, and query status.
  • Click on a query to see detailed information (SQL command, execution time, resources used).
• Benefits: Easy to use, provides a quick overview of your query history.

2. Query History API

• Documentation: https://docs.databricks.com/api/workspace/queryhistory
  • Features: Programmatic access to query history data.
  • Retrieve query details, filter, and sort results.
• Benefits: Enables automation and integration with other systems.

3. Serverless Compute Query History

• Availability: If your workspace is enabled for serverless computing.
• Features: Includes both SQL and Python queries run in notebooks and jobs.
• Benefits: Comprehensive view of query history across different execution environments.

4. Table Access Control (TAC) Logs

• Location: “DatabricksTableAccessControl” log table.
• Features: Tracks table usage and access.
• Benefits: It provides insights into how tables are used and who is accessing them.

Retention Period

Query history data is typically retained for 30 days and then automatically deleted.