topic Re: How do I get the total number of queries run per day on a databricks SQL warehouse/endpoint? in Data Engineering

How do I get the total number of queries run per day on a databricks SQL warehouse/endpoint?

207474 — Mon, 18 Jul 2022 12:24:52 GMT

I am trying to access the API:

GET https://<databricks-instance>.cloud.databricks.com/api/2.0/sql/history/queries

Re: How do I get the total number of queries run per day on a databricks SQL warehouse/endpoint?

AmanSehgal — Tue, 19 Jul 2022 02:28:21 GMT

Use the above API with HTTP security scheme type.

http://<db_worksapce>.cloud.databricks.com/api/2.0/sql/history/queries

Create a PAT Token in warehouse and use it for bearer token.

Say you want to generate your report for 13th July +0 UTC and 14th July +0 UTC.

Start time: Jul 13 2022 00:00:00 - start_time_ms: 1657720800000

End time: Jul 14 2022 00:00:00 - end_time_ms: 1657756800000

Your request will look like this:

{
    "filter_by": {
        "query_start_time_range": {
            "end_time_ms": 1657756800000,
            "start_time_ms": 1657720800000
 
    },
    "statuses":["FINISHED","FAILED"],
    "warehouse_ids":
        [
            "<warehouse_id>"
        ]
    },
    "include_metrics": true,
    "max_results": 100
}

In response from the API, the number of entries inside "res" is equal to number of queries run per day on your provided warehouse_id.

Re: How do I get the total number of queries run per day on a databricks SQL warehouse/endpoint?

Vidula — Mon, 05 Sep 2022 10:17:53 GMT

Hi there @Sravan Burla

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!

Re: How do I get the total number of queries run per day on a databricks SQL warehouse/endpoint?

ChristinaSmith — Tue, 08 Aug 2023 09:44:59 GMT

Thank you, you saved my job.