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. Type as Functionality Like SQL

    As provided in SQL, I want to use TYPE AS Table in DW stored procedure.

    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 →
    • Load subset of files in Azure blob storage to SQL data warehouse

      Let's say we have following files in Azure blob storage with same file format but different number/type of data in their columns:
      fileA_1.csv
      fileA_2.csv
      fileB_1.csv
      fileB_2.csv

      If PolyBase supports defining data source to blob storage with defined file title format (for instance: WHERE file.name = 'fileA_*.csv'), we will be able to transfer various files from same location to desired external tables.

      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  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
      • unit test framework

        The open source tsqlt framework requires CLR which is not available in Azure SQL DW. A framework to to write unit tests would increase trust in the queries.

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

          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 →
          • 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 →
            • Blend with azure sql as a node

              Would want to do this is restricted special curcumstances:

              Add Azure sql db as another worker mode so that queries can run across both the cold and hot data from one interface. Specify resource constraints on the hot data queries and automatic data migrations (based on rules?) between environments. Bonus if this could on on-prem environments.

              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 of StorageTable as DataSource

                Please add support of Azure TableStorage as PolyBase DataSource.
                To be honest I can't believe its not already available. :O

                15 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 →
                • unicode compression

                  Support Unicode compression or similar.

                  As per https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression unicode compression is not supported in SQL DW.

                  We currently have to trade-off between significantly increased data size and support for non-latin characters. With predominantly latin data it would be good to not have to choose.

                  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 →
                  • Support JSON Data handling in ADWH

                    as well as Azure SQL-Database & SQL-Server 2016 support the Set of JSON-Functions:

                    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  ·  T-SQL  ·  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 ?

                      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 →
                      • Support ALTER AUTHORIZATION for all relevant object classes

                        Need to be able to change the ownership of any object in ADW that has an owner. For example a ROLE. Currently only DATABASE, SCHEMA, and OBJECT are suported.

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

                          6 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 ANSI INTERVAL data types in CREATE TABLE

                            Need to support ANSI INTERVAL data types in CREATE TABLE so applications can be ported from other data warehouse offerings.

                            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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                            • Enable SQL DW as data source for external tables in SQL DB

                              Querying SQL DW from SQL DB via external tables currently does not work due to an implicit SET LANGUAGE statement issued by the elastic queries component. It sets the Language to N'us_english' (not supported) vs. us_english (supported I guess). Same for SET NUMERIC_ROUNDABORT, set to OFF (not supported). While you can explicitly set the NUMERIC_ROUNDABORT to ON at run-time, you cannot do SET LANGUAGE us_english on SQL DB. Maybe other issuesd are to be found but this scenario is important.

                              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  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
                              • Support for updating statistics on a single partition

                                This would increase update statistics performance for users who are currently loading data into a single partition and updating statistics afterwards.

                                Otherwise with growing data size, updating statistics takes longer after every load.

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

                                    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 →
                                    • Polybase: Remove/increase row size from 32k

                                      Polybase is currently limited to a maximum row size of 32k. Request that this be increased by orders of magnitude.

                                      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  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
                                      • APS: Improve on control node bottleneck for data return rate

                                        With AU4 it was claimed that the data return rate for APS should improve for select * queries

                                        The real world improvements do not seem to exist from this feature and the control node seems to still be a big bottleneck for this kind of task being saturated with 100% CPU Load.

                                        The scenario in which we need this is when processing a large cube with plenty of large partitions being processed in parallel.

                                        Compare my screenshot for figures from our environment.

                                        Specs:
                                        APS HP Half rack (Patch: v10.0.8026.0)
                                        40 core E7-8891 v2 512GB RAM + 12TB FusionIO SSAS only…

                                        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

                                          1 comment  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
                                        • SSMS support for APS/PDW

                                          I understand SSMS supports Azure DW, that should make it even easier to add the support for APS/PDW in SSMS.

                                          6 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 6 7 8
                                          • Don't see your idea?

                                          Feedback and Knowledge Base