Enable elastic query for SQL DW - this would allow cross database query in SQL DataWarehouse.105 votes
Thanks for the suggestion. We are looking into this scenario for a future release. 7558005
This would allow an enterprise to have a Production Data Warehouse with SLAs in place while allowing a data scientist/Business user/Subject matter expert to do analytic and discovery work without impacting SLAs and without moving data (which usually is pretty large).
At the same time it would allow for metered consumption and chargeback towards the subtenants that are conducting analytic discovery work.
The functionality would be similar to what can already be done today with HDInsight and Azure Blob. Data in Azure blob can be independently accessed by multiple HDInsight clusters.23 votes
Thanks for the suggestion. We are looking into this scenario for a future release. 7557959
CTAS to a new table is often a pattern that's used in DW for data processing workloads. Instead of RENAME OBJECT operations from old tables to the new ones using CTAS, it would be great if we can add synonym support to DW, so that switching to the new table is an atomic operation, and is reliable.15 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 10698241
It would be very nice to have something like a page with Release Notes after every update to Azure DWH.
Now you accidentally find out that something that did not work , works.13 votes
Thanks for the suggestion. We are working on getting release notes out quickly.
Any web app or excel addin for master data management on Azure SQL DW would be useful.9 votes
Thanks for your suggestion. We will look into this feature for a future release. 8425777
Azure SQL DW does not support SSIS Profiling Task because PERMISSIONS function is not supported. It would be good if we would be able to profile data directly in ADW.7 votes
Exclusive locks wait until all the select queries on the tables are completed.Instead if an option is given to switch between locking mechanism (i.e either use FIFO locking mechanism or the current locking mechanism)2 votes
Capability to monitor progress for transaction rollback2 votes
I'm having an issue where I've a pipeline which calls an SP on Azure SQL DW. I've set an interval of 15 minutes, however a new run starts as soon as one of the run finishes. It appears that it does not look at the interval.2 votes
Can you share more details on this feature request? Is this a feature request for SQL DW or a tool which is connecting to SQL DW?
- Don't see your idea?