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

    192 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      6 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
    • Use SELECT for setting variables (SELECT @MyVar = Col1, @MyVar1 = Col2 ...)

      Because we cannot do SELECT @MyVar = Col1, we are forced to utilize the same code to execute the exact same sql, to assign multiple variables.

      52 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        started  ·  0 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.

        44 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          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.

          36 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 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…

            31 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
            • 25 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

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

                23 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 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

                  23 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    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.

                    18 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      5 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                    • DROP IF EXISTS

                      Support DROP IF EXISTS

                      16 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        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

                        14 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          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.

                          10 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            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.

                            9 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • ALTER DATABASE SCOPED CREDENTIAL

                              Currently a user cannot change the Identity and\or Secret in the DATABASE SCOPED CREDENTIALS until they drop all objects which use the credentials. I ran a quick test and confirmed that you cannot DROP a CREDENTIAL unless you first drop all DATA SOURCEs using the credential, and you cannot drop the DATA SOURCEs until you drop all FILE FORMATs with dependencies, and you cannot drop FILE FORMATs until you drop all external tables with dependencies. This is very painful for customers.

                              This capability does exist within Azure SQL DB, so we ask that this be supported in Azure SQL DW.

                              9 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 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'.

                                9 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 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

                                  8 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    10 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?

                                    7 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

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

                                      7 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                      • 5 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Support "DATEDIFF_BIG", like Azure SQL

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

                                          5 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

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

                                          Feedback and Knowledge Base