Can we get SQL Serverless warehouses monitoring data using APIs or logs ?

RahulChaubey
New Contributor III

‎04-15-2024 06:22 AM

I am looking for a possible way to get the autoscaling history data for SQL Serverless Warehouses using API or logs.
I want something like what we see in monitoring UI. 

Screenshot 2024-04-15 at 6.52.29 PM.png

 

 

0 Kudos

artsheiko
Databricks Employee
Databricks Employee

‎04-16-2024 04:38 AM

Hi Rahul, you need to perform two actions : 

  1. Enable system tables schema named "compute" (how-to, take a look on the page, it's highly possible that you'll find other schemas useful too)
  2. Explore system.compute.warehouse_events table

Hope this helps.

Best regards,

Artem

View solution in original post