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.
Download the Visual Studio 2019 preview here: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-install-visual-studio951 votes
SSDT is now generally available!
Please view and share below:
Thank you everyone who helped provide feedback!
Currently Synapse On-Demand SQL doesnt support stored procedures. In case the On-Demand logic is to be operationalized or used from Synapse Orchestrate\ADF, it will be helpful to have stored procedures instead of copying data between external tables or building views combining different files.10 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
Bulk Insert is available in SQL DB today. Recent updates allow it to load from Azure Storage Blobs.
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
We are moving to SHOWPLAN as the model for exposing query details. We have recently released full SHOWPLAN_XML support with graphical execution plans in SSMS 17.5. You can see the blog announcement here:
You can download SSMS here:
- Don't see your idea?