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. 1 vote
    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 →
    • 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

      3 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 →
      • Add "DROP Partition" command

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

        1 vote
        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 →
        • Grant DDL, DML rights with expiry date

          Some time, we need to give access on production environment for a certain time period, either its select, ddl or dml. Currently its a manual process to revoke the access or we have to develop a process and routines to revoke them. It will be good if we could provide an expiry date with the grant statement it self and DBMS engine should auto take care of expiry on that date.

          1 vote
          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 →
          • 4 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 →
            • 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

              1 vote
              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 →
              • 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 →
                • 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

                  11 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 →
                  • SET DATEFIRST to values other than 7

                    Currently SET DATEFIRST allows only to set value to 7 (Sunday)
                    This van be an issue when dealing with different geogrpahies where the first day of the week is supposed to be Monday, i.g.: affecting sales distribution. Please allow values other than 7 for DATEFIRST

                    3 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

                      22 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 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 →
                        • SET TRANSACTION ISOLATION LEVEL

                          Supporting "READ COMMITTED"

                          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 →
                          • 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 )

                            3 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 →
                            • sp_help

                              Support sp_help

                              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 →
                              • column default

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

                                4 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 →
                                • 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 →
                                  • 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 →
                                    • 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 →
                                      • @@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…

                                        30 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 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 →
                                          ← Previous 1
                                          • Don't see your idea?

                                          Feedback and Knowledge Base