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.
-
MERGE statement support
Support the MERGE sql statement to support management of SCD1 / SCD2
387 votesThank you for your suggestion. We are planning to support this feature.
-
ANSI joins support in UPDATE & DELETE statement
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.
125 votes -
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 Rename110 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
…( SELECT99 votes -
68 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.
62 votes -
DROP IF EXISTS
Support DROP IF EXISTS
56 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
34 votesThank you for the feedback. We are reviewing the request.
-
23 votes
Thanks for your suggestion. We are looking into this scenario for a future release. 10703657
-
Add "DROP Partition" command
Having drop Partition command that automatically merges the partition boundaries and removes the partition would help a lot.
22 votesThank you for your request. This item is on our backlog. We will update this thread when the state changes.
-
Allow DBCC results (e.g. DBCC PDW_SHOWSPACEUSED..) to be copied into yet another table for programmatic interaction with those results?
IF OBJECTID('tempdb..#showspace_used') IS NOT NULL
DROP TABLE #show_space_usedCREATE TABLE #show_space_used
(
[ROWS] INT NULL
, [RESERVED_SPACE] INT NULL
, [DATA_SPACE] INT NULL
, [INDEX_SPACE] INT NULL
, [UNUSED_SPACE] INT NULL
, [PDW_NODE_ID] INT NULL
, [DISTRIBUTION_ID] INT NULL
)
WITH
(
DISTRIBUTION = HASH([ROWS])
, HEAP
)DECLARE @DynamicSQL nvarchar(4000)
SET @DynamicSQL = (SELECT CONVERT(NVARCHAR(100),'DBCC PDW_SHOWSPACEUSED("dbo.TableName");'))INSERT INTO #showspaceused ([ROWS], [RESERVEDSPACE], [DATASPACE], [INDEXSPACE], [UNUSEDSPACE], [PDWNODEID], [DISTRIBUTIONID])
EXEC spexecutesql @Dynamic_SQLMsg 103010, Level 16, State 1, Line 326
Parse error at line: 25, column: 1: Incorrect…21 votesThank you for your request. This item is on our backlog. We will update this thread when the status changes.
-
column default
Support column default with expression. (E.g. Getdate())
19 votes -
Add support for the truncate partition option
Add support for the option to truncate a single partition in a table (as per sql azure and sql 2016).
https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql
15 votesThank you for your request. This item is on our backlog. We will update once the item state changes.
-
Remove Scalar Function limitiations
Currently we can not do the following:
use Global variables within UDF, which makes us to send it from the front end as a value. eg; @@DateFirst
reference tables within the UDF
reference temp tables within a UDF15 votesThanks for your suggestion. We are looking into this scenario for a future release. 10703219
-
Allow results of a Stored procedure call to be stored to a table.
APS PDW on-Prem... I'm having to create a permanent table with session Id as part of the key to be able to pass record sets back and forth between stored procedure calls. I'd like to at least be able to declare a table variable, and populate it with the results of a stored procedure call.
13 votes -
Feature request: cursors
Will cusors (https://msdn.microsoft.com/en-us/library/ms180169.aspx) be available anytime in future in Azure SQL Data Warehouse?
13 votesThanks for the request. This item is currently on our backlog. We will update this thread when the state changes.
-
Not to be locked at CREATE / DROP USER
If you execute CREATE / DROP USER during updating query execution, a wait occurs when trying to acquire an exclusive lock.
11 votesThanks for your suggestion. We are looking into this scenario for a future release. 10698260
-
sp_help
Support sp_help
11 votesPlease help describe the scenario for this.
-
Multi-column IN / NOT IN subquery
Support multi-column IN/NOT IN subquery like:
select
*
from
schema_name.table
where(c1, c2) in ( select c1, c2 from schema_name.t2 )8 votes -
Support "DATEDIFF_BIG", like Azure SQL
pretty useful for device data (IoT), often has in sub seconds
8 votesWe have started on the request for DATEDIFF_BIG support.
- Don't see your idea?