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. sql server 2016 polybase data lake store

    On prem Polybase should support Azure Data Lake Store and push down query to Azure Data Lake Analytics

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

        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

          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 …

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

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

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

                  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

                    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

                    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 →
                    • 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 →
                        • Expose Explain Plan XML Schema

                          In order to build up tooling around the Explain Plan output having the XML Schema published and versioned is key. By having access to the schema, it will allow for integrator and ISV partners to know the shape of XML and properties contained in it.

                          This will allow for easier integration to allow for processing etc. of the XML to help DW Users derive insight from the content of the Explain operation.

                          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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
                          • CONCAT_WS

                            Add CONCAT_WS in Azure SQL DW. It exists in SQL Azure but not in Azure DW.

                            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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                            • SQL DW password policy profiles

                              We have multi-factor authentication (MFA) for AAD. Tableau and other tools connecting to data sources via ODBC cannot accommodate MFA. We can create local accounts in Azure SQL Server and SQL DW, but MUST CHANGE, CHECK EXPIRATION, and CHECK POLICY are not supported. We need to be able to enforce and report compliance with password security policies.

                              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  ·  Security  ·  Flag idea as inappropriate…  ·  Admin →
                              • Create specific API REST operation for scaling instead of using the generic POST

                                Because the scaling operation is included in the generic write operation, if we need to configure a least privileges permission we would need to add the ability to create and update a database, which is way more than allowing just to scale a database.

                                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  ·  Security  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add Split_part function to SQL DW

                                  Just enable what's already in SQL (STRING_SPLIT) - it's the closest I've found to Redshift SPLIT_PART.

                                  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  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow Bulk insert from blob storage

                                    Due to the limitations currently in polybase its not an option for a lot of data sources. It would be great to be able to use bulk insert off blob storage like what is enabled in Azure SQL database as an option at least in the meantime.

                                    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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Limit the size of ORC files produced by CREATE EXTERNAL TABLE AS SELECT command

                                      Recently I worked with Microsoft support on an issue using CREATE TABLE AS SELECT to import data from external tables using ORC file format. Most queries completed just fine, but some ran into errors like "Java heap space". Those queries were hitting external tables backed by huge ORC files (ranged from 17GB to 33GB per file). The product team confirmed there is a design limit that makes those files unqualified. I then split the files further down to less than 12GB per file (total data volume was kept the same) and the CTAS queries then ran just fine.
                                      So obviously…

                                      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  ·  Polybase  ·  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 →
                                        • database level firewall

                                          The following documentation states that a database level firewall works for Azure SQL DW databases:
                                          https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-set-database-firewall-rule-azure-sql-database

                                          However, running the syntax mentioned results in the error:
                                          Msg 15165, Level 16, State 1, Line 1
                                          Could not find object 'sp_set_database_firewall_rule' or you do not have permission.

                                          Please add or fix support for the database-level firewall in Azure SQL DW

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

                                          Feedback and Knowledge Base