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. 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 →
    • 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 →
      • 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 →
          • Explain plan in SSMS returned as XML data type

            In SSDT if you connect a query window to Azure SQL DW and put EXPLAIN in front of a query and run it you get back an XML data type column and clicking on the XML pops open a new XML window.

            In SSMS when you do the same the column is a text column, not XML. As a result, most large explain plans get truncated because the length of a text column returned in SSMS is smaller than the length of an XML column.

            Please change EXPLAIN plan queries to return as XML data type so that it's more…

            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 →
            • Azure Data Factory loading to Azure DWH - Polybase permissions

              When using Polybase to load into Data Warehouse via Data Factory, Control permission on the database is required for the user.
              Can this be limited to a Schema Owner, or be more granular at the database level ?

              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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
              • Automatic Generation and Updating of table statistic

                It would be great if table statistics were automatically created and updated in Azure Data Warehouse.

                17 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                • Allow install of Linux ODBC to be automated via puppet

                  Allow install of Linux ODBC to be automated via puppet. The current Microsoft SQL Server ODBC packages can't be installed via puppet as they require EULA acknowledgment. If we adopted the ADW technology, we would inevitably have to install the ODBC software on several grids of computers that host our various ETL software. Puppet installation allows the implementers of new systems to get the software automatically installed without the DBA team's intervention.

                  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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                  • Cancel Query in sqlcmd

                    Need to be able to cancel a query running from sqlcmd (on Linux) without terminating the session as KILL 'SIDxxxxx' does

                    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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                    • Pause Resume Azure SQL Data Warehouse Using SQL Command

                      It would be great if we can have SQL command to Pause/Resume DB instance like how we do for Scale up/down (under Master DB). This will help us to manage the same from ADF and don't have to worry about trigger REST API or PowerShell

                      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

                        0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                      • For APS PDW, add abiltiy to name indexes within the create table script and from visual studio script the indexes with thier names.

                        We have a naming standard for our indexes but since we can't script the name of the index in a create table command, we have to use a separate create index command. This is a bit of a hassle when moving objects around. Viewing the code of a table in Visual Studio does not include the index names so when we use this function we have to manually change the script it generates.

                        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 →
                        • Expand size of LABEL in query logs

                          The LABEL column in the sys.dm_pdw_exec_requests DMV is limited to 255 characters.

                          This field needs to be much larger to store rich metadata/context of some queries.

                          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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                          • Log the columns, tables, views, schemas, procedures, indices, etc used in a query

                            Allow proper due diligence to be done in introducing DDL change. Some object usage is not evident in the SQL text due to semantic layers, generated SQL, etc.

                            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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                            • Space quota at schema level

                              Need to be able to specify a space quota for a schema and abort current work that causes the quota to be exceeded.

                              Forces user groups to be good stewards and manage their storage usage or be prevented from additional 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                              • APS Backup to Name instead of IP

                                Right now the only supported way to backup APS is to an IP Address (UNC path), please add the ability to backup to a FQDN path.

                                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 →
                                • Backup on Pause/Resume

                                  At the moment the automated backup process take place every 8 hours unless the database is paused. Upon resumption of the database, it appears that it has to be online for 8 hours before the next backup is taken.

                                  If resuming and then pausing the system again it is possible to go for a long duration without backups. Could you please evaluate the potential of taking an automatic backup either when the database is paused or resumed.

                                  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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Provide a way to expose the actual DWU usage (not the same as the scale setting).

                                    You can see what the database is scaled to i.e. DWU 200, but how do you know how much is actually being used over time. The portal display a graph of both the DWU limit and the DWU used but there is no way to programmatically monitor how much is being used.

                                    17 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 →
                                    • Run queries from Web Interface

                                      Installing SSMS or VS in order to be able to access Azure SQL DW is a heavy and cumbersome operation.

                                      Exposing a web interface to run queries will make the product much more accessible and user friendly.

                                      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

                                        1 comment  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Implementing elastic pools for Azure SQL Data Warehouse

                                        A customer asked if there are plans to implement some sort of elastic pools where you can include many data warehouses and share DWU (eDWU?) the same way elastic database pools work with SQL Databases.

                                        12 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Manual Backup and Restore process for SQLDW

                                          Currently SQLDW doesn't have capability to backup manually to any storage. That would be very important as a end user to have capability to manually backup the entire SQLDW. Furthermore, it would be useful to specify longer term retention capabilities as released for SQL DB recently.

                                          34 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

                                            7 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          SQL Data Warehouse

                                          Feedback and Knowledge Base