topic How can I retrieve the total count of requests processed by the SQL warehouse during a given period? in Warehousing & Analytics

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

Pramod_G — Wed, 26 Mar 2025 17:55:54 GMT

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.

Re: How can I retrieve the total count of requests processed by the SQL warehouse during a given per

Shua42 — Thu, 27 Mar 2025 14:58:00 GMT

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.