We want to be flexible and if some teams needs to access sqlwarehouse thru Azure Active Directory instead of local DB Users it will be great and easy to provide access to data1 vote
In order to build up tooling around the Explain Plan output having the XML Schema published and versioned is key. By having access to the schema, it will allow for integrator and ISV partners to know the shape of XML and properties contained in it.
This will allow for easier integration to allow for processing etc. of the XML to help DW Users derive insight from the content of the Explain operation.3 votes
Due to the limitations currently in polybase its not an option for a lot of data sources. It would be great to be able to use bulk insert off blob storage like what is enabled in Azure SQL database as an option at least in the meantime.4 votes
Various tools generate dynamic SQL and fail due to the limit "
Case expressions may only be nested to level 10"5 votes
Can you add support for replication from SQL server to Azure Data warehouse , or some sort of Log Shipping or mirroring ?
Enable some seamless replication between on premise database to Azure data warehouse , this can be using replication , log shipping , mirroring or some sync Agent deployed on premise . Using SSIS packages to sync huge databases takes a lot of work and wouldn't be as robust .3 votes
Please enable geographically distributed Data Warehouse.
Different part of the data should be located in different clouds because of legal issues.
EXAMPLE: we have sales data from US in one cloud, and from Europe in another. With one query, we would be able to consume total sales from Europe and US.5 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 8315023
Why not implement a Sql server 'Replication' solution from sql server (on premise / Azure) to sql dataware house (on Azure)?
It would be useful if we have a processing DB in sql server and a accumulating datawarehouse in sql datawarehouse, with not too many structural changes.21 votes
Thank you for raising this, we have heard this ask a few times and will look into some of the ways that we may accomplish this. 7693854
Database project from Visual Studio is useful to manage DDLs, schema compare between the project and database, etc. Please create a project template dedicated for DW or support DW development from Database Project.372 votes
We apologize this is taking longer than we’d like. As soon as this is on our roadmap, we will periodically reach out with updates. Please continue voting for this feature and comment on your scenario below. Thank you for all the feedback! 6882139
Support for Entity Framework in Azure SQL Data Warehouse would allow for greater usability in general, but it would also allow for better support of other frameworks/protocols. Specifically, we have a need to serve our data through an OData feed, and Entity Framework's deferred execution would allow us to handle OData's Query Options in a much simpler way.93 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 8315007
- Don't see your idea?