Enable elastic query for SQL DW - this would allow cross database query in SQL DataWarehouse.120 votes
Thanks for the suggestion. We are looking into this scenario for a future release. 7558005
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.44 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 10698241
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
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.18 votes
Thanks for the suggestion. We are working on getting release notes out quickly.
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.8 votes
Intellisense is a very handy feature when using SSMS to write queries against Sql Server databases. It increases development time by reducing typographical errors.
It would be nice to have with Sql Data Warehouse.7 votes
Thank you for all the feedback folks. Unfortunately full intellisense support for SSMS is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update.
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
Thank you for the feedback. We are continuously improving the monitoring experience with SQL Data Warehouse. We will reach back out when this capability is on the roadmap and can share when we have an update.
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
Is this still an issue? If not, we will close the item to clean the backlog.
- Don't see your idea?