How to auto resume dedicated pool from a query and auto pause from inactivity

Question

Hi all, I have 2 pipelines for pausing and resuming the dedicated pool based on schedule, these are working fine but there are times that users need to run queries against the dedicated pool outside of the working hours (when the dedicated pool is paused). Is it possible to change this schedule approach to event based? i.e. when someone runs a query against the dedicated pool, it resumes the dedicated pool and once there is no activity, the dedicated pool goes back to being paused.

Answer 1

Hello Ayomide Siwoku, My understanding is you can implement an event-based approach for pausing and resuming a dedicated pool in Azure Synapse Analytics using Azure Logic Apps. You can create a Logic App that is triggered by an event, such as an HTTP request, and then use an HTTP action to send a POST request to the Azure Synapse REST API to resume the dedicated pool.

Once there is no activity, you can use another Logic App to pause the dedicated pool. You can also use Azure Monitor to monitor the activity in the dedicated pool and trigger the Logic App based on custom logic.

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api

I hope this helps.