topic Re: Can we get SQL Serverless warehouses monitoring data using APIs or logs ? in Get Started Discussions

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

RahulChaubey — Mon, 15 Apr 2024 13:22:59 GMT

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.

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

artsheiko — Tue, 16 Apr 2024 11:38:49 GMT

Hi Rahul, you need to perform two actions :

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)
Explore system.compute.warehouse_events table

Hope this helps.

Best regards,

Artem