Azure Synapse Analytics
-
[In preview] Database project from Visual Studio to support Azure SQL Data Warehouse
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-studio
951 votesSSDT is now generally available!
Please view and share below:
Thank you everyone who helped provide feedback!
-
Stored procedure support for On-Demand SQL
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 -
Allow Bulk insert from blob storage
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 votesBulk Insert is available in SQL DB today. Recent updates allow it to load from Azure Storage Blobs.
https://docs.microsoft.com/en-us/sql/t-sql/statements/bulk-insert-transact-sql?view=sql-server-2017 -
Expose Explain Plan XML Schema
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 votesWe 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:
https://azure.microsoft.com/en-us/blog/unlock-query-performance-with-sql-data-warehouse-using-graphical-execution-plans/You can download SSMS here:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
- Don't see your idea?