Allowing user to use local timezone is very necessary, it's not easy for users to change their programs to meets UTC timezone.
Allowing user to use local timezone is very necessary, it's not easy for users to change their programs to meets UTC timezone.3 votes
Users now can use AT TIME ZONE TSQL command to convert an inputdate to the corresponding datetimeoffset value in the target time zone.
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.24 votes
Thank you for the suggestion. We have been publishing release on our documentation site at:
Columnstores can eliminate segments based on the min/max vaules of a column.
For best performance, the data would need to be sorted by the users desired column, such as a date.
I'd love to see a syntax that looks something like the below (but without the need for creating a clustered index first)
DISTRIBUTION = hash ( [store] ),
clustered columnstore index (order by DateStamp)
Ordered clustered Columnstore index is now supported by Azure Synapse SQL Analytics (formerly known as Azure SQL Data Warehouse).
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.
Just enable what's already in SQL (STRINGSPLIT) - it's the closest I've found to Redshift SPLITPART.29 votes
The STRING_SPLIT function is now available in production.
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!
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
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).
Please add support of JSON data format like just happened for SQL Server 2016 and Azure SQL Database with JSONVALUE, JSONQUERY, etc.133 votes
The support for new JSON TSQL functions are already available in the Azure Data Warehouse.
We announced GA support for this at Ignite Nov. 2019.
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.
If SET tables aren't available, at least allow an UNIQUE INDEX to be placed on a table if the DISTRIBUTION column is found in the columns of the UNIQUE INDEX
Table with locationid and productid with any number of fact columns. Partition the table by productid. All the data for any productid will be on one specific distribution. Allow that distribution to enforce uniqueness on locationid + productid.7 votes
Primary key and unique constraints are now supported by Azure Synapse SQL Analytics tables.
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.
It would be great to implement Row-Level Security on SQL Data Warehouse.
That would be a great solution for scenarios where (for example) we have clients like PowerBI using data from SQL warehouse, and persons who have limited data access.159 votes
Let's say you define an external table with:
REJECT_VALUE = 1000,
REJECT_TYPE = value
That means that it can reject and discard 1000 rows without failing the entire command.
Please enhance Polybase to give us visibility into which rows were rejected and why. I would propose you can define an error output file where rejected rows get written. Either that or let us query some DMV to get a copy of the complete row as a string and the error reason.112 votes
We are happy to announce that this is completed.
Please look at the release blog https://azure.microsoft.com/en-us/blog/load-confidently-with-sql-data-warehouse-polybase-rejected-row-location/ for more information.
With OLTP SQL, the command xp_logininfo helps mapping out security and would be helpful in APS.1 vote
Thank you for your suggestion. This request has been forwarded to the APS team for consideration in a future release. 11022371
Display the total size of the data warehouse including snapshots/restore points and geo-backups. This will help customer project storage costs of the data warehouse.20 votes
We like to scale to DW100 during low demand.
The minimum DW for Gen2 is DW1000. This represents a 10x cost increase during these hours.
We are blocked from migrating until there is a DW100 equivalent.10 votes
Thank you for your suggestion. We now offer lower Azure SQL Data Warehouse Gen2 SKUs – all the way down to DWU100c. Please see our announcement here:
When will the upgrade to the latest version of Azure DW be available in the North Europe region?1 vote
We have announced the GA for the Gen2 offer today! See the global announcement here:
We launched our Gen 2 offer in 20 regions today including both Europe (North and West) regions.
When backups are running, cannot run queries.3 votes
Please submit a support ticket if backups are impacting your workload. We have had various improvements to limit disruption of workloads during automated snapshots.
- Don't see your idea?