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

    565 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

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

      Thank you for your patience. This is currently on our road map. Please continue voting for this feature and comment on your scenario below. We’ll reach out when preview is available to everyone who voted for this feature.

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

      115 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        9 comments  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
      • 84 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          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.

          27 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            Thank you for voting on this feature. Please describe your scenario in the thread below. We currently have many migration solutions from SQL Server to SQL Data Warehouse such as Azure Data Factory and Redgate through the Quick Load Azure portal experience (link below). If this is a continuous replication process, we’d love to understand your hybrid scenario so please comment below.

            https://azure.microsoft.com/blog/enhanced-loading-monitoring-and-troubleshooting-experience-for-azure-sql-data-warehouse/

          • 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
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  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
                Signed in as (Sign out)

                We’ll send you updates on this idea

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

                We currently support geo-backups to a secondary region. This item is under review for active geo-replication of a SQL Data Warehouse with cross database querying. Please vote for this feature here and comment with your scenario below. Thank you for your patience.

              • Azure Active Directory (AAD) Connectivity to SQL Warehouse thru Excel

                We want to be flexible and if some teams needs to access sqlwarehouse thru Azure Active Directory instead of local DB Users it will be great and easy to provide access to data

                3 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  Integration  ·  Flag idea as inappropriate…  ·  Admin →
                • I have source as a flat file having data in multiple lines in a string column, when I insert the same data into Azure SQL Datawarehouse data

                  I have source as a flat file having data in multiple lines in a string column, when I insert the same data into Azure SQL Datawarehouse database, its removing the new line characters and data is appearing in a single line.

                  I checked the data by copying into Notepad++ , its appearing in a single line.

                  Is there any option in Azure SQL Datawarehouse database to fix this issue.

                  Example: CREATE TABLE test ( ID VARCHAR(20) , TASK NVARCHAR(100) ) WITH ( CLUSTERED INDEX ( ID ) )

                  Insert into table with multiple lines in TASK field

                  insert into test…

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

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

                  SQL Data Warehouse

                  Feedback and Knowledge Base