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. Challenges with backups

    When backups are running, cannot run queries.

    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  ·  Flag idea as inappropriate…  ·  Admin →
    • Challenges with failed queries

      Challenges with failed queries
      o The partner has experienced failed queries consistently
      o The failures generally equate to times where maintenance on a node is occurring
      o The system should be resilient to this

      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  ·  Flag idea as inappropriate…  ·  Admin →
      • challenges with concurrency model

        Challenges with concurrency model
        o The partner would like more control on how many concurrency slots a query has
        o The partner suggests that the concurrency slot choices are too limiting (1,2,4,8,16,32,64). They would like to choose the number of slots 1-80
        o The partner would like to be able to dynamically change the number of slots - or have the system dynamically change for them
        o An example of the rigidity is if the partner has 2000 DWUs - and thus 80 concurrency slots - and they have a large query running taking 64 slots, another large query would…

        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  ·  Flag idea as inappropriate…  ·  Admin →
        • Challenges with billing model

          Challenges with billing model
          o Partner has to pay while SQL DW is scaling up
          o Partner has to pay for queries that fail. Partner has had consistent query failures
          · 1 per week
          · Queries may be long running - over an hour
          · Upon failure, the partner still had to pay for the SQL DW compute
          o Partner prefers more of a service model where they pay for query execution not infrastructure
          · They prefer a model like Azure Data Lake Analytics
          · They do not prefer to have to scale up and down themselves
          · Their preference…

          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  ·  Flag idea as inappropriate…  ·  Admin →
          • Support MERGE T-SQL statement

            Customer requires SQLDW to support the MERGE T-SQL statement for their UPSERT task to work.

            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  ·  Flag idea as inappropriate…  ·  Admin →
            • Support for MapR on Polybase

              MAPR are encountering a stumbling block in the lack of support for MapR on Polybase.

              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  ·  Flag idea as inappropriate…  ·  Admin →
              • APS/SQLDW does not support ODBC required api stored procedures for SAP Business Objects

                APS/SQLDW does not support ODBC required api stored procedures for SAP Business Objects.

                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  ·  Flag idea as inappropriate…  ·  Admin →
                • Support rebuilding DW indexes with Online = ON so the table is accessible during the rebuild

                  This works:
                  ALTER INDEX ALL ON VulnerabilityScope REBUILD
                  But, when the rebuild takes place, the entire table becomes locked from any query--even selecting one row. Users complain when the table is inaccessible during the 30 minute rebuild.

                  This currently returns an error:
                  ALTER INDEX ALL ON VulnerabilityScope REBUILD WITH (ONLINE = ON)
                  Parse error at line: 1, column: 48: Incorrect syntax near 'ONLINE'.

                  Please support rebuilding DW indexes with Online = ON

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

                      0 comments  ·  Polybase  ·  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

                        0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
                      • Resource Governance - Resource Pools - Control CPU, physical IO, memory, priority, run-time cap, max request, concurrency, request timeout..

                        1. Ability to manage workloads effectively
                        2. Enables to specify limits on the amount of CPU, physical IO and memory
                        3. User-Defined Resource Pools
                        a. Memory size
                        b. Memory cap
                        c. CPU
                        d. Maximum requests
                        e. Grant time-out
                        f. Priority
                        g. Concurrency
                        h. Run-time cap

                        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

                          4 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                        • Ignore update when there are no changes

                          In DW project, usually there are scenarios where full data load of dimension happens. Even if there are no attributes changes, the timestamp of the records get change and that causes cascading impact in the DW system, wherein dependent facts and dimension are full processed. This is very resource intensive task and causes entire DW facts recreation.

                          To avoid this, it would be good to have a T-SQL syntax wherein it checks the required attributes between the incoming record and the destination and updates if and only if the attribute is change. eg:

                          UPDATE Emp UPDATE WHEN Name, DOB CHANGED …

                          2 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  ·  Performance  ·  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

                            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 →
                            • Enable Scale and Start in the same command/API call

                              I should not have to start Azure SQL Data Warehouse, wait for it to resume then issue a scale and wait again.

                              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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                              • scheduled Auto Scale Up/Down for Azure SQL DWs on Azure Portal

                                CAn you please provide the Auto scale up and Down functionality along with Alerts mechanism in Azure portal .

                                2 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  ·  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.

                                  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 →
                                  • Enable Dynamic compute - scaling up the DW should not kill any existing query

                                    Scaling up/down the warehouse kills all ongoing sessions.
                                    Adding or removing compute capacity should be truly dynamic. This means that when I add more compute - by scaling up - the DW should be able to absorb that additional compute capacity without killing existing queries.
                                    Maybe that compute can be brought into play for the new queries that get submitted post addition of the compute.

                                    Thanks,
                                    Mayank

                                    13 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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Increase Concurrency limit as a tweakable system parameter

                                      Increase the concurrency limit from 32 to unlimited and keep it tweakable , so the customers can vary it according to their needs

                                      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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Persist Data dictionary to a separate database for DBA

                                        Persist Data dictionary to a separate database by allowing the customer to persist the DMV, which can be used by DBA for fixing performance issues

                                        2 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Change - Exclusive lock queries wait until all select queries are complete

                                          Exclusive locks wait until all the select queries on the tables are completed.Instead if an option is given to switch between locking mechanism (i.e either use FIFO locking mechanism or the current locking mechanism)

                                          2 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          SQL Data Warehouse

                                          Feedback and Knowledge Base