SQL DW does not support to usual way of joins (ANSI) in UPDATE, DELETE statement. This makes difficult in case of table data modification. Though there is a workaround provided for CTAS this seems to be a lengthy process of data modification. Please have this feature available in SQL DW.136 votes
This feature is now available in the May release of Azure Synapse Analytics (formerly Azure SQL DW).
Azure SQL DW does not support tryconvert or trycast function in T-SQL. This is must needed function to validate the conversion of data types. We have custom date conversion function which uses try_convert to convert different date formats and getting on standard date format out. Please include this feature Azure SQL DW.78 votes
These two functions are now supported by Azure SQL DW.
Because we cannot do SELECT @MyVar = Col1, we are forced to utilize the same code to execute the exact same sql, to assign multiple variables.59 votes
This syntax is now available for use.
To run global reporting, need to support 'AT TIME ZONE' as found in SQL Server 2016 - https://msdn.microsoft.com/en-us/library/mt612795.aspx45 votes
The customer I’m working with is asking if there’s a way to know the full length of T-SQL statements that are run in an Azure SQL Data Warehouse instance.
They are using sys.dmpdwexec_requests, but it truncates the query text keeping 4000 bytes.34 votes
We are excited to announce that we have implemented Query Store for Azure SQL Data Warehouse. Query Store enables storing the full query text and aggregated execution statistics for all queries for a period of 7 days. You can learn more about Query Store in our blog post:
Principal Program Manager
Azure SQL Data Warehouse team
Include string manipulation functions already available in other sql editions/versions like string_agg, string_split etc29 votes
String_Agg and String_Split are not supported by Azure Synapse SQL Analytics.
Azure SQL DWH doesn't support ROWS UNBOUNDED PRECEDING and similar RANGE inside OVER clause. This is quite painful, because it's frequently used for querying data warehouse.16 votes
Thanks again to all of you for sharing your feedback with us. We have completed this feature and it has now been deployed world wide. 7207037
Support for creating, maintaining and using indexed views (https://msdn.microsoft.com/en-us/library/ms191432.aspx) would be very benefical for increasing query performance.14 votes
Azure Synapse SQL Analytics now supports Materialized View.
Supporting "READ COMMITTED"10 votes
Read committed snapshot isolation is now supported by Azure Synapse SQL Analytics (formerly known us Azure SQL Data Warehouse).
Currently a user cannot change the Identity and\or Secret in the DATABASE SCOPED CREDENTIALS until they drop all objects which use the credentials. I ran a quick test and confirmed that you cannot DROP a CREDENTIAL unless you first drop all DATA SOURCEs using the credential, and you cannot drop the DATA SOURCEs until you drop all FILE FORMATs with dependencies, and you cannot drop FILE FORMATs until you drop all external tables with dependencies. This is very painful for customers.
This capability does exist within Azure SQL DB, so we ask that this be supported in Azure SQL DW.10 votes
This feature is now complete. Documentation will reflect this change shortly!
Implement the Checksum built-in sql function.5 votes
CHECKSUM and BINARY_CHECKSUM support has been rolled out worldwide. 7195154
If I try to create a scalar function in Azure SQL DW in a schema other than DBO I get:
Msg 110813, Level 16, State 1, Line 41
Invalid operation. The connection is closed.
If I change to dbo then it succeeds.5 votes
This feature is now supported by Azure SQL Data Warehouse. Thank you for taking the time to submit your feedback!
Kind Regards, JRJ
Principal PM Azure SQL Data Warehouse
When exporting data from SQL DW using SQLCMD the row count is always written at the end. This means that the output has to be parsed and the message stripped to import this file. It would be nice to be able to SET NOCOUNT OFF so that this message is removed. It would also be nice to support SET NOCOUNT ON as some query tools require this support in order to avoid error messages.2 votes
This feature has been released.
This sequence of statements doesn't work, after the USE statement, the context is still on master database, anything we execute will be on master.
Create Database NYTaxi2
2020/05/21 – this should work now
- Don't see your idea?