SQL Data Warehouse

Do you have an idea or suggestion based on your experience with SQL Data Warehouse? We would love to hear it! Please take a few minutes to submit your idea or vote up an idea submitted by another SQL Data Warehouse customer. All of the feedback you share in these forums will be monitored and reviewed by the SQL Data Warehouse engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. MERGE statement support

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

    96 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  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. @@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
    88 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. 62 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  ·  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.

    58 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  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  7. DROP IF EXISTS

    Support DROP IF EXISTS

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add "DROP Partition" command

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

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  11. 17 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. column default

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

    17 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  ·  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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    10 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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  ·  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  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  18. sp_help

    Support sp_help

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

    We’ll send you updates on this idea

    5 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  19. Support "DATEDIFF_BIG", like Azure SQL

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

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  20. Enable Debugging für SQL DW

    We are migrating SQL Scripts written for MS SQL Server 2008 R2 which contain a lot of dynamic SQL. At this moment one of those scripts fails pointing to row 1 column 1. There is no logic in that row. Inserting print 'Step x reached' shows me, that the script fails at a part where 100 lines of a dynamic SQL are stored in a variable of type NVARCHAR(4000). I believe 4000 chars is not enough to capture this dynamic SQL. Nonetheless I would like to be 100% sure before I start re-engineering this script. When I start the debugger…

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

    We’ll send you updates on this idea

    3 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback folks. We are actively looking into this scenario specifically with VS SSDT Database Project support with SQL Data Warehouse. Please continue voting and monitoring this item for updates. Thank you for your patience.

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base