Azure Synapse Analytics

We would love to hear your ideas for new features for Azure Synapse Analytics. Below, enter a new idea or upvote an existing one. The Synapse engineering team pays attention to all requests.

If instead you need a technical question answered or help, try the these options: DocumentationMSDN forum, and StackOverflow. If you need support, please open a support ticket.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. [In Preview] MERGE statement support

    Support the MERGE sql statement to support management of SCD1 / SCD2

    427 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    23 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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 Rename

    134 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. @@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 row
    count <> -1
    AND request_id IN

                    (   SELECT
    111 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  5 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. 81 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. DROP IF EXISTS

    Support DROP IF EXISTS

    66 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    63 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add WAITFOR command to SQL Datawarehouse

    The following wont compile on ADW

    IF @count = 4

                BEGIN
    
    WAITFOR DELAY &#39;00:30&#39;;
    SET @count = 0;
    END

    Please allow WAITFOR command on ADW

    40 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  8. 26 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add "DROP Partition" command

    Having drop Partition command that automatically merges the partition boundaries and removes the partition would help a lot.

    23 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. column default

    Support column default with expression. (E.g. Getdate())

    22 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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_used
    
    

    CREATE 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 @Dynamic
    SQL = (SELECT CONVERT(NVARCHAR(100),'DBCC PDW_SHOWSPACEUSED("dbo.TableName");'))

    INSERT INTO #showspaceused ([ROWS], [RESERVEDSPACE], [DATASPACE], [INDEXSPACE], [UNUSEDSPACE], [PDWNODEID], [DISTRIBUTIONID])
    EXEC sp
    executesql @Dynamic_SQL

    Msg 103010, Level 16, State 1, Line 326
    Parse error at line: 25, column: 1: Incorrect…

    22 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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 UDF

    17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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

    16 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  16. sp_help

    Support sp_help

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  18. Support of iif/choose logical function

    Azure SQL DW does not support IIF and CHOOSE logical function while SQL Server, SQL DB and SQL MI support it. It would be good to support them to reduce the gap between SQL services.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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  )
    

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  20. Support "DATEDIFF_BIG", like Azure SQL

    pretty useful for device data (IoT), often has in sub seconds

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base