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. Support for Clustered Column Store indexes on large objects

    Support clustered column store indexes on large objects like varchar(max)/nvarchar(max)

    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

      1 comment  ·  Table Structure  ·  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 →
      • Support Global Temporary Tables

        Allow the DDL to be specified once for a temporary table and then let applications instantiate an instance of the table in their sessions when the object is referenced (with an INSERT statement) if not already created in the session.

        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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
        • Allow Unique Index on Columns that intersect the distribution column

          If SET tables aren't available, at least allow an UNIQUE INDEX to be placed on a table if the DISTRIBUTION column is found in the columns of the UNIQUE INDEX

          For example

          Table with location_id and product_id with any number of fact columns. Partition the table by product_id. All the data for any product_id will be on one specific distribution. Allow that distribution to enforce uniqueness on location_id + product_id.

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

            Allow table to be created as SET and not only MULTISET.

            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 →
            • 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 →
              • Stuff.....For XML

                Please provide support for STUFF......FOR XML so we can do complex concatenation using Azure Data Warehouse. Right now its kind of show stopper for us due to time taken by workarounds (while loop).

                30 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 →
                • Support for Recursive CTE

                  It would be great if you can add support for recursive CTEs for computing hierarchical data

                  51 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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                  • Support for creation of user defined types

                    Currently, there is no support for user defined types which is making it difficult for us to migrate code from Azure SQL to Azure SQL DWH.

                    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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                    • Add support of JSON format

                      Please add support of JSON data format like just happened for SQL Server 2016 and Azure SQL Database with JSON_VALUE, JSON_QUERY, etc.

                      42 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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                      • Support for XML datatype

                        XML datatype is not supported in ADW now.

                        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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                        • Provide File Format to read JSON and XML data from Storage

                          Able to read the JSON and XML file as part of external system OR provide functionality like Extractor in Data Lake analytics so we can write our own Extractor to read respective data format.

                          47 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 →
                          • More Collation support + ability to set via the Portal

                            Right now according to the documentation the only options for collation on SQL Data Warehouse are "The default collation is SQL_Latin1_General_CP1_CI_AS. The other collation option is Latin1_General_100_CI_AS_KS_WS."

                            We run Latin1_General_CI_AS which I suspect a large amount of UK customers would do. This is a supported Collation as per SQL Azure which we are migrating our operational datastore to but we can't move our data warehouse because of this. Also like SQL Azure can we have this as an option via the management portal when we create a DW.

                            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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                            • Support for spatial data type

                              Spatial data shlould be supported by SQL Data Warehouse the same way it is supported by SQL Server.

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

                              Feedback and Knowledge Base