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

      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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
      • Raise limit for nested case expressions from 10

        Various tools generate dynamic SQL and fail due to the limit "
        Case expressions may only be nested to level 10"

        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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
        • Can you add support for replication from SQL server to Azure Data warehouse , or some sort of Log Shipping or mirroring ?

          Enable some seamless replication between on premise database to Azure data warehouse , this can be using replication , log shipping , mirroring or some sync Agent deployed on premise . Using SSIS packages to sync huge databases takes a lot of work and wouldn't be as robust .

          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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
          • Geo Distributed Data Warehouse

            Please enable geographically distributed Data Warehouse.
            Different part of the data should be located in different clouds because of legal issues.

            EXAMPLE: we have sales data from US in one cloud, and from Europe in another. With one query, we would be able to consume total sales from Europe and US.

            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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
            • 70 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  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
              • 'Replication' solution from sql server to sql dataware house?

                Why not implement a Sql server 'Replication' solution from sql server (on premise / Azure) to sql dataware house (on Azure)?
                It would be useful if we have a processing DB in sql server and a accumulating datawarehouse in sql datawarehouse, with not too many structural changes.

                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

                  1 comment  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
                • Database project from Visual Studio to support Azure SQL Data Warehouse

                  Database project from Visual Studio is useful to manage DDLs, schema compare between the project and database, etc. Please create a project template dedicated for DW or support DW development from Database Project.

                  346 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

                    32 comments  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →

                    Thank you for all the feedback folks. While we understand the scenario here and would love to enable this feature, unfortunately this is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update. 6882139

                  • Support for Entity Framework

                    Support for Entity Framework in Azure SQL Data Warehouse would allow for greater usability in general, but it would also allow for better support of other frameworks/protocols. Specifically, we have a need to serve our data through an OData feed, and Entity Framework's deferred execution would allow us to handle OData's Query Options in a much simpler way.

                    89 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

                      8 comments  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
                    • Don't see your idea?

                    SQL Data Warehouse

                    Feedback and Knowledge Base