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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    under review  ·  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

    81 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(row_count) AS row_count
    FROM sys.dm_pdw_sql_requests
    WHERE row_count <> -1
    AND request_id IN
    ( SELECT TOP 1 request_id
    FROM sys.dm_pdw_exec_requests
    WHERE…

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

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. support for TRY_CONVERT or TRY_CAST functions

    Azure SQL DW does not support try_convert or try_cast function in T-SQL. This is must needed function to validate the conversion of data types. We have custom date conversion function which uses try_convert to convert different date formats and getting on standard date format out. Please include this feature Azure SQL DW.

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

    We’ll send you updates on this idea

    planned  ·  6 comments  ·  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.

    59 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. 58 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 →
  8. DROP IF EXISTS

    Support DROP IF EXISTS

    50 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 →
  9. Support 'AT TIME ZONE'

    To run global reporting, need to support 'AT TIME ZONE' as found in SQL Server 2016 - https://msdn.microsoft.com/en-us/library/mt612795.aspx

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

    We’ll send you updates on this idea

    4 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. 28 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 →
  11. Add WAITFOR command to SQL Datawarehouse

    The following wont compile on ADW

    IF @count = 4
    BEGIN
    WAITFOR DELAY '00:30';
    SET @count = 0;
    END

    Please allow WAITFOR command on ADW

    26 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 →
  12. Allow DBCC results (e.g. DBCC PDW_SHOWSPACEUSED..) to be copied into yet another table for programmatic interaction with those results?

    IF OBJECT_ID('tempdb..#show_space_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 @Dynamic_SQL nvarchar(4000)
    SET @Dynamic_SQL = (SELECT CONVERT(NVARCHAR(100),'DBCC PDW_SHOWSPACEUSED("dbo.TableName");'))

    INSERT INTO #show_space_used ([ROWS], [RESERVED_SPACE], [DATA_SPACE], [INDEX_SPACE], [UNUSED_SPACE], [PDW_NODE_ID], [DISTRIBUTION_ID])
    EXEC sp_executesql @Dynamic_SQL

    Msg 103010, Level 16, State 1, Line 326
    Parse error at line: 25, column: 1: Incorrect syntax near 'EXEC'.

    18 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 →
  13. Add "DROP Partition" command

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

    17 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. 16 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 →
  15. column default

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

    16 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 →
  16. 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 →
  17. 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

    14 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. Feature request : Indexed Views

    Support for creating, maintaining and using indexed views (https://msdn.microsoft.com/en-us/library/ms191432.aspx) would be very benefical for increasing query performance.

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

    We’ll send you updates on this idea

    started  ·  0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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 →
  20. 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 →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base