Auto-suspend and Auto-resume
I would absolutely magic if we had something like Snowflake:
- Automatically suspends the warehouse if no query has been issued during a fixed amount of time
- Automatically resumes the warehouse when a query is issued
Paul Wehland commented
It would also be great if we can set auto-shutdown times like we can with Azure VM's. This should be set in the Portal. It saves massive costs, when you forget about a VM running. The same could be implemented for Synapse DW. For exaple; set the time to auto-shutdown at 21:00 each night. Then you have one less thing to remember to do.
This is a preview feature (serverless compute) now that you can request access to