Azure Synapse Analytics
-
Shrinkdatabase command support
Shrinkdatabase command should to be supported even if TDE is on or off because extra cost is charged in case that the unallocated space is huge.
89 votesThank you for all the feedback folks. We understand the scenario and are actively working on improving this experience. We will reach back out when it is addressed and share when we have an update.
-
Enable Intellisense With SSMS
Intellisense is a very handy feature when using SSMS to write queries against Sql Server databases. It increases development time by reducing typographical errors.
It would be nice to have with Sql Data Warehouse.
83 votesThank you for all the feedback folks. Unfortunately full intellisense support for SSMS is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update.
-
[In preview] More flexible date formats in Polybase
This feedback item is currently in preview here:
https://docs.microsoft.com/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest
Polybase currently has very limited date format support. All of the acceptable date formats have dashes or slashes. For example, I can't define a date format of yyyyMMdd since it doesn't have slashes or dashes. Please allow any date format I can express.
Also, please allow more than one date format per external table. For example, what if I have a date column as yyyyMMdd and then a different column as yyyyMMddHHmm. With only being able to define one date format in the CREATE EXTERNAL FILE FORMAT statement I think I…
82 votes -
Restore single table from backup
The ability to restore a single table from backup, to an existing DW, would greatly assist in recovering from errors.
81 votes -
DROP IF EXISTS
Support DROP IF EXISTS
80 votes -
Enable Dynamic compute - scaling up the DW should not kill any existing query
Scaling up/down the warehouse kills all ongoing sessions.
Adding or removing compute capacity should be truly dynamic. This means that when I add more compute - by scaling up - the DW should be able to absorb that additional compute capacity without killing existing queries.
Maybe that compute can be brought into play for the new queries that get submitted post addition of the compute.Thanks,
Mayank76 votes -
Pause Resume Azure SQL Data Warehouse Using SQL Command
It would be great if we can have SQL command to Pause/Resume DB instance like how we do for Scale up/down (under Master DB). This will help us to manage the same from ADF and don't have to worry about trigger REST API or PowerShell
73 votesThank you for voting for this feature. We understand this scenario and will consider this in a future release. For now, please continue monitoring this item and have your team vote for this feature. Thank you for your patience.
-
[In preview] Inline and Table Valued Function support
This request is currently in Preview:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=sqlallproducts-allversionsCurrently Functions can only return a single variable, but we need to be able to return full tables so we can use them within the WHERE clause.
71 votesInline Table Valued Functions are currently in Preview. Will be supported in tooling in coming months.
-
Resource Governance - Resource Pools - Control CPU, physical IO, memory, priority, run-time cap, max request, concurrency, request timeout..
- Ability to manage workloads effectively
- Enables to specify limits on the amount of CPU, physical IO and memory
- User-Defined Resource Pools
a. Memory size
b. Memory cap
c. CPU
d. Maximum requests
e. Grant time-out
f. Priority
g. Concurrency
h. Run-time cap
70 votesThis is available for public preview as announced at Ignite this November, 2019.
-
Table Extended Properties
Add the ability to store table extended properties so that meta data about the table can be stored. This will help with self documentation to aid BI Developers.
67 votesThanks for your suggestion. We are looking into this scenario for a future release. 7350424
-
Stuff.....For XML
Please provide support for STUFF......FOR XML so we can do complex concatenation using Azure Data Warehouse. Right now its kind of show stopper for us due to time taken by workarounds (while loop).
65 votes -
Support Always encrypted in SQL Data warehouse
Always Encrypted makes the data to be only available to client side applications and not visible to Database administrators also. It makes the data to be more secure. It is especially needed in the case of Azure, where PII data is stored in cloud.
63 votesThanks for your suggestion. We are looking into this scenario for a future release. 6386782
-
Delta lake support to SQL on Demand
Currently, Delta lake table is not supported to be queried using SQL on Demand. Adding this functionality would help to greatly use SQL on-demand for analyzing the delta lake table.
This will save time to query any Spark database delta lake table without spinning spark pools.
61 votes -
Automatic Generation and Updating of table statistic
It would be great if table statistics were automatically created and updated in Azure Data Warehouse.
60 votesWorking on now. Should be out in the next few months!
-
Add support for synonyms
CTAS to a new table is often a pattern that's used in DW for data processing workloads. Instead of RENAME OBJECT operations from old tables to the new ones using CTAS, it would be great if we can add synonym support to DW, so that switching to the new table is an atomic operation, and is reliable.
59 votes -
Add WAITFOR command to SQL Datawarehouse
The following wont compile on ADW
IF @count = 4
BEGIN
WAITFOR DELAY '00:30';
SET @count = 0;
ENDPlease allow WAITFOR command on ADW
57 votesThank you for the feedback. We are reviewing the request.
-
Support table variables
Prior to data analysis it is required to collect some initial info and store it in a table format. Creating and dropping a table or a temp table takes too much time (seconds) since it has to be distributed over multiple nodes. Having table variables would solve this performance issue.
57 votes -
unit test framework
The open source tsqlt framework requires CLR which is not available in Azure SQL DW. A framework to to write unit tests would increase trust in the queries.
51 votesThank you for your feedback folks. We are actively looking into this scenario specifically with SSDT Database Project support with SQL Data Warehouse. Please continue voting and monitoring this item for updates. Thank you for your patience.
-
Implementing elastic pools for Azure SQL Data Warehouse
A customer asked if there are plans to implement some sort of elastic pools where you can include many data warehouses and share DWU (eDWU?) the same way elastic database pools work with SQL Databases.
48 votesThank you for all the feedback folks. This is on our radar and we will consider this in a future release. We will reach back out when it is on the roadmap and can share when we have an update. Please vote for this feature and comment on your scenario below.
-
Polybase to treat \N as NULL (or allow custom null support)
I was trying to load external file into SQL DW table using polybase. This external file has \N as value for null columns. For example :
2,"C1008",1,\N,1,1,"2016-02-09 23:13:02","2014-02-21 20:11:36","2016-02-08 17:48:59","2008-07-16 14:17:40",947
I defined external data format as below:
CREATE EXTERNAL FILE FORMAT TextFileFormat
WITH
( FORMATTYPE = DELIMITEDTEXT
, FORMATOPTIONS ( FIELD_TERMINATOR = ',', STRING_DELIMITER = ''
, USE_TYPE_DEFAULT = FALSE
));
when i try to load this record into DW table, I am getting below error:
Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected…
47 votesThank you for the request. This item is currently on our backlog and under review. We will update the item when the status changes.
- Don't see your idea?