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. 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 →
    • 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  ·  T-SQL  ·  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 →
        • 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

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

            11 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  ·  T-SQL  ·  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.

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

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

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

                    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 →
                    • Add support for synonyms

                      CTAS to a new table is often a pattern that's used in DW for data processing workloads. Instead of RENAME OBJECT operations from old tables to the new ones using CTAS, it would be great if we can add synonym support to DW, so that switching to the new table is an atomic operation, and is reliable.

                      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

                        1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                      • 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 →
                        • DROP IF EXISTS

                          Support DROP IF EXISTS

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

                              3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Allow DWU to scale without interruption

                              The scaling disrupts the current session, and it's often not allowable in the production. Instead, it should finish off the existing session (sqls), and scale after that. That way, the scaling up or down can be done without causing the production disruption.

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

                                16 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 →
                                • Table Extended Properties

                                  Add the ability to store table extended properties so that meta data about the table can be stored. This will help with self documentation to aid BI Developers.

                                  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

                                    2 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Enable distribution elimination in the generated query plan if the query predicate contains the distribution key column as a filter

                                    Say we have the following table:

                                    CREATE TABLE [dbo].[Foo]

                                    (

                                    [columnWithGuids] [uniqueidentifier] NULL,

                                    [column1] [int] NULL,

                                    [column2] [bigint] NULL,

                                    [ingressDay] [date] NULL

                                    )

                                    WITH

                                    (

                                    DISTRIBUTION = HASH ( [columnWithGuids] ),

                                    CLUSTERED COLUMNSTORE INDEX,

                                    PARTITION

                                    (

                                    [ingressDay] RANGE RIGHT FOR VALUES (N'2016-01-01T00:00:00.000', N'2016-01-02T00:00:00.000')

                                    )

                                    )

                                    And we have a query:

                                    SELECT

                                    SUM([colum1]) AS [Total]

                                    ,[ingressDay]

                                    FROM [dbo].[Foo]

                                    WHERE [columnWithGuids] = '40300bab-03aa-8d51-7ecb-904dfaf47ec7'

                                    GROUP BY

                                    [ingressDay];


                                    Currently, Azure SQL DW does not eliminate distributions to interrogate based on a predicate. Which means, that in the above case, even though only 1 distribution will always have the data we're looking for, it will…

                                    11 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 →
                                    • PolyBase: Support newline/carriage return in delimited text

                                      Polybase fails to read rows if a [delimited] text column contains a newline/carriage return character even if they are within a text delimiters

                                      take this example: I write a line to a external table using CETAS and cannot read the very same table again:

                                      CREATE EXTERNAL TABLE stage.testNewLine WITH
                                      (
                                      LOCATION = 'archive/NewLine',
                                      DATA_SOURCE = myDatasource,
                                      FILE_FORMAT = myFormat
                                      )
                                      AS
                                      SELECT
                                      'regular Text' AS Col1,
                                      'Line1
                                      Line2' AS Col2

                                      SELECT *
                                      FROM stage.testNewLine

                                      Everything that is written to SQL DW using INSERT should be able to be retrieved again using SELECT

                                      28 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 →
                                      • TRANSACTION support for RENAME

                                        Since MERGE statement is not supported, we are using CTAS for preparing the new table and using the rename operation.

                                        Currently we do not have the TRANSACTION support for the RENAME operations.

                                        When we have two rename operations we may run into inconsistent state if second statement fails.

                                        RENAME OBJECT FinalTable TO FinalTable_Old;
                                        RENAME OBJECT FinalTable_Stage TO FinalTable;

                                        To overcome this, we need some workaround or support for transactions.

                                        24 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  ·  Reliability  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Polybase support for other cloud data sources

                                          we currently has Polybase to Azure Blob Store.

                                          we need Polybase to the following data stores:

                                          HDInsight with push down compute?
                                          SQL Azure with push down compute?
                                          DocumentDB with push down compute?
                                          Azure Data Lake Store with push down to Azure Data Lake Analytics?

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

                                          Feedback and Knowledge Base