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

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

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

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

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

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

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

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

                        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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                        • Predicate pushdown for ADLS sources

                          As Azure SQL DW now also supports ADLS, it would be great if we could also leverage the distributed processing capabilities of ADLS to push computation down to ADLS in a similar way as it works for HDFS/Hadoop already

                          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 →
                          • Automatic Generation and Updating of table statistic

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

                            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 →
                            • 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 →
                              • allow polybase export

                                support

                                EXEC sp_configure 'allow polybase export', '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  ·  Polybase  ·  Flag idea as inappropriate…  ·  Admin →
                                • Polybase to treat \N as NULL

                                  I was trying to load external file into SQL DW table using polybase. This external file has \N as value for null columns. For example :

                                  2,"C1008",1,\N,1,1,"2016-02-09 23:13:02","2014-02-21 20:11:36","2016-02-08 17:48:59","2008-07-16 14:17:40",947

                                  I defined external data format as below:

                                  CREATE EXTERNAL FILE FORMAT TextFileFormat
                                  WITH
                                  ( FORMAT_TYPE = DELIMITEDTEXT
                                  , FORMAT_OPTIONS ( FIELD_TERMINATOR = ','
                                  , STRING_DELIMITER = ''
                                  , USE_TYPE_DEFAULT = FALSE
                                  )
                                  );

                                  when i try to load this record into DW table, I am getting below error:

                                  Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected out of…

                                  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

                                    1 comment  ·  Polybase  ·  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 →
                                    • Support Always encrypted in SQL Data warehouse

                                      Always Encrypted makes the data to be only available to client side applications and not visible to Database administrators also. It makes the data to be more secure. It is especially needed in the case of Azure, where PII data is stored in cloud.

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

                                        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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Using APS PDW on-prem. Not having Primary Key Constraints is a big issue.

                                          I've had to create an audit process using a control table that holds the primary key columns for all the tables and a procedure that spins through all the tables looking for duplicate counts based off those keys. After 2 years of adding tables with no validation for this, the first time I ran the audit 6 months ago, it found duplication in more than 10-20% of our tables. We're still cleaning up our legacy ETL feeds and removing duplicates. Looking for and cleaning up duplicates after they hit the system is very inefficient.

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

                                          Feedback and Knowledge Base