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.

How can we improve Microsoft Azure SQL Data Warehouse ?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

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

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

    276 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

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

      75 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

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

        55 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

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

          45 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            43 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

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

              42 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
              • 37 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                • Support for the full length of T-SQL statements that are run in an Azure SQL Data Warehouse

                  The customer I’m working with is asking if there’s a way to know the full length of T-SQL statements that are run in an Azure SQL Data Warehouse instance.
                  They are using sys.dm_pdw_exec_requests, but it truncates the query text keeping 4000 bytes.

                  31 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

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

                    Thank you for your feedback folks! We have already started working on this feature specifically Query Data Store for SQL Data Warehouse. Please continue having your team and customers vote for this feature and we’ll reach out when it is available.

                  • DROP IF EXISTS

                    Support DROP IF EXISTS

                    28 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

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

                      27 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

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

                        15 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

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

                          14 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                          • 14 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              2 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

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

                                11 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                • Feature request: cursors

                                  Will cusors (https://msdn.microsoft.com/en-us/library/ms180169.aspx) be available anytime in future in Azure SQL Data Warehouse?

                                  11 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 10 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Add "DROP Partition" command

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

                                      10 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                      • SET TRANSACTION ISOLATION LEVEL

                                        Supporting "READ COMMITTED"

                                        9 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

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

                                          9 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

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

                                          SQL Data Warehouse

                                          Feedback and Knowledge Base