Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1 ACCEPTED SOLUTION
Accepted Solutions
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2024 04:38 AM
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
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2024 04:38 AM
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