How can I retrieve the total count of requests processed by the SQL warehouse during a given period?

[Pramod_G]

Hi,

I need to create a dashboard displaying the total number of requests per status that have been processed or are currently being processed by the SQL warehouse.

I noticed the default graph for the SQL warehouse shows the number of queries executed per minute within a 2-hour window.

I appreciate your help.

[Shua42]

You can use the system table for this, system.query.history, which is now in public preview: https://docs.databricks.com/aws/en/admin/system-tables/query-history

It contains the full query history for warehouses, including status, executer, query text duration, etc. Just note that view access needs to be granted by an admin.