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

[RahulChaubey]

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. 

 

[artsheiko · Accepted solution]

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