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

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

      75 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

        5 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

        73 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

          under review  ·  3 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.

          65 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

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

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

              XML datatype is not supported in ADW now.

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

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

                  9 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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                  • enable DML-Trigger

                    Table Trigger are very helpful f.e. auditing DML-code execution.

                    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

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

                        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

                          0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                        • sort a columnstore on CTAS/rebuild

                          Columnstores can eliminate segments based on the min/max vaules of a column.

                          For best performance, the data would need to be sorted by the users desired column, such as a date.

                          See - http://www.nikoport.com/2014/04/16/clustered-columnstore-indexes-part-29-data-loading-for-better-segment-elimination/

                          I'd love to see a syntax that looks something like the below (but without the need for creating a clustered index first)

                          with
                          (
                          DISTRIBUTION = hash ( [store] ),
                          clustered columnstore index (order by DateStamp)
                          )

                          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  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                          • Distribute nulls evenly - to avoid skew when using hash distribution

                            My best candidate distribution key is 40% nulls.

                            At present, distributing on this value will result in one overloaded distribution, where all the nulls will land.

                            As nulls will never join to any other table, it would suit this use case to have equal distribution of null rows across all distributions, so that the non-null foreign keys can benefit from being distribution aligned.

                            I understand this would be a change in behaviour, so perhaps a new distribution option could be created i.e. HASH_AND_NULL(my_foreign_key)

                            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

                              1 comment  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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
                                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
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

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

                                    We’ll send you updates on this idea

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

                                  SQL Data Warehouse

                                  Feedback and Knowledge Base