Implementing elastic pools for Azure SQL Data Warehouse
A customer asked if there are plans to implement some sort of elastic pools where you can include many data warehouses and share DWU (eDWU?) the same way elastic database pools work with SQL Databases.
Thank you for all the feedback folks. This is on our radar and we will consider this in a future release. We will reach back out when it is on the roadmap and can share when we have an update. Please vote for this feature and comment on your scenario below.
This would be excellent for multi-tenant reporting solutions. Currently, DWUs are assigned per-Data Warehouse. We want to pool this resource across multiple data warehouses.
This would be of great value for our multiple dev/test environments.
laura edell commented
Something like elastic pools for DW to share the resource burden would be huge. This is an ask for the #1 consumer of Azure as of 2017.
Are you thinking of something like elastic database pools where DWU is configured for a pool and is shared among all DWs in the pool? If so, please add your vote/requirements to the existing suggestion: https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/14204067-implementing-elastic-pools-for-azure-sql-data-ware
Se Hee Lee commented
The idea of having DWU per database is great, but why stop there?
Why can't you allow the DWU at the farm level?
Farm can be made of many databases, and you can control the DWU for all.
For service provider such as us, we can have a separate database per our customers while enjoying a same DWU across all.
This spreads the cost down drastically for us as not all customers are using the database extensively.