Azure Synapse Analytics
Do you have an idea or suggestion based on your experience with Azure Synapse Analytics? We would love to hear it!
Remember that this site is only for feature suggestions and ideas! If you have technical questions please try our documentation, MSDN forum, or StackOverflow. If you need support, please open a support ticket with us.
-
User Defined Retention Periods for Restore Points
SQL DW doesn't have the capability to specify longer term retention capabilities as released for SQL DB recently. The workaround is to restore and pause. It would be great to have this capability for compliance and auditing requirements.
168 votesThank you for voting for this feature! We are aware of this scenario and are looking into ways of supporting this. In the meantime, stay tuned for an update and please continue voting for this feature.
-
Support for Entity Framework
Support for Entity Framework in Azure SQL Data Warehouse would allow for greater usability in general, but it would also allow for better support of other frameworks/protocols. Specifically, we have a need to serve our data through an OData feed, and Entity Framework's deferred execution would allow us to handle OData's Query Options in a much simpler way.
158 votesThank you for all the feedback folks. Unfortunately this 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.
-
Expose File Properties as additional columns to load in SQL DW
It would be helpful if some of the properties of a BLOB file could be exposed in the external table such as: Last Modified, Filename, Size. It should be optional and could be defined in the EXTERNAL FILE FORMAT definition. Each Property should be appended to the end of the result set of an external table in the order given in the definition.
For instance, if we are loading a directory of several files we can read the filename and derive a new column. For example, we might have a directory with 20160504.csv and 20160505.csv and the contents of the…
122 votesThanks for your suggestion. We are looking into this scenario for a future release. 7633537
-
Support for Recursive CTE
It would be great if you can add support for recursive CTEs for computing hierarchical data
112 votes -
Support for spatial data type
Spatial data shlould be supported by SQL Data Warehouse the same way it is supported by SQL Server.
111 votes -
Allow DWU to scale without interruption
The scaling disrupts the current session, and it's often not allowable in the production. Instead, it should finish off the existing session (sqls), and scale after that. That way, the scaling up or down can be done without causing the production disruption.
110 votesThank you for voting for this feature! We are aware of this scenario and are looking into ways of supporting this. In the meantime, stay tuned for an update and please continue voting for this feature.
-
Lower scale points for Dev/Test environments
SQL Data Warehouse scale stepping should be much smaller (10 DWU or even 1 DWU), than 100 DWU!
Please fix that ASAP!
Thank you!103 votesThank you for all the feedback folks. We are currently evaluating options for lower click stops for SQL Data Warehouse. Please continue to vote and comment on your scenario below. Thank you for your patience.
-
Rename a column name in SQLDW
Scenario: We want to change the column name as it is changed in the source. And in table where we are trying to do has more than 20Billion records.
Workaround: Since rename of column is not possible currently in SQL DW we are doing CTAS of that big table.
Issues With Work around: It is very slow because we can’t do CTAS on entire big table in single transaction because of transaction limits and we end up doing in CTAS and with multiple insert statements . Which is very time consuming process
ASK: Please support column Rename97 votes -
Provide File Format to read and load JSON and XML data from Storage
Able to read the JSON and XML file as part of external system OR provide functionality like Extractor in Data Lake analytics so we can write our own Extractor to read respective data format.
92 votes -
@@ROWCOUNT Support
Please enable @@ROWCOUNT?
Furthermore considering that we cannot switch NOCOUNT on, then why should it be such a secret/coded mission to track the number of rows affected by the most recent snippet of code? The proposed work-around seems onerous and doesn't always work (for dynamic SQL) yet my query window still knows and always-prints the fact that it returned 15 rows to me, for example, so why can we not leverage this elementary information inside the selfsame query (?):
SELECT SUM(rowcount) AS rowcount
FROM sys.dmpdwsqlrequests
WHERE rowcount <> -1
AND request_id IN
…( SELECT90 votes -
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.
88 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.
-
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).
67 votes -
65 votes
-
Inline and Table Valued Function support
Currently 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.
59 votes -
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.
51 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
50 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.
-
Temporal Table support in AzureSQLDW
Is this on the roadmap? Currently they are not a thing in the Parallel DW:
https://msdn.microsoft.com/en-us/library/dn935015.aspx?f=255&MSPPError=-214721739650 votesThanks for your suggestion. We are looking into this scenario for a future release. 10714515
-
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.
49 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.
-
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…
44 votesThank you for the request. This item is currently on our backlog and under review. We will update the item when the status changes.
-
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.
42 votesThanks for your suggestion. We are looking into this scenario for a future release. 7350424
- Don't see your idea?