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

        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  ·  Other  ·  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 →
          • SSIS Data Profiling Task in Azure SQLDW

            Azure SQL DW does not support SSIS Profiling Task because PERMISSIONS function is not supported. It would be good if we would be able to profile data directly in ADW.

            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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
            • Capability to monitor progress for transaction rollback

              Capability to monitor progress for transaction rollback

              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 →
              • Microsoft APS : Please increase Sessions from current 32 (Load 10 ,Query 22) to greater than 64

                Microsoft APS : Please increase Sessions from current 32 (Load 10 ,Query 22) to greater than 64

                Justification : in real world we are seeing more adhoc users usage + Loads so 32 is very small which is creating huge ripple effect on APS Query Performance & user satisfaction.

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

                  Any web app or excel addin for master data management on Azure SQL DW would be useful.

                  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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                  • Cross Database Querying

                    Enable elastic query for SQL DW - this would allow cross database query in SQL DataWarehouse.

                    76 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                    • Alow multiple SQL DataWarehouse instances to access the same data (.mdf files)

                      This would allow an enterprise to have a Production Data Warehouse with SLAs in place while allowing a data scientist/Business user/Subject matter expert to do analytic and discovery work without impacting SLAs and without moving data (which usually is pretty large).
                      At the same time it would allow for metered consumption and chargeback towards the subtenants that are conducting analytic discovery work.
                      The functionality would be similar to what can already be done today with HDInsight and Azure Blob. Data in Azure blob can be independently accessed by multiple HDInsight clusters.

                      21 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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                      • Pipelines running continuously

                        I'm having an issue where I've a pipeline which calls an SP on Azure SQL DW. I've set an interval of 15 minutes, however a new run starts as soon as one of the run finishes. It appears that it does not look at the interval.

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

                        Feedback and Knowledge Base