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 spatial data type

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

    99 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support for Recursive CTE

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

    97 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    84 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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).

    62 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    35 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support for XML datatype

    XML datatype is not supported in ADW now.

    28 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  8. enable DML-Trigger

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

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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)
    )

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  12. unique index

    Pls add feature to hash distribute data using an identity column

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support for Clustered Column Store indexes on large objects

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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)

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  15. Validate the credentials on the Import Database Screen and provide error on that page before submitting the task to execute.

    This would give instant and clear feedback to the user that the credentials are not valid.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  16. Support for rowversing

    ADW has no embedded mechanism for us to detect what data was recently created/modified.
    Compared to replication or CDC I suspect supporting rowversioning and delete triggers would be the simplest way.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  17. Partition Elimination(PartionBy) Support in External Tables

    On ADLS when there is large amount of Data Querying via External Table is very slow. Would be nice to have some Query optimizer kind on feature that would improve and read performance and only scan related folder & file on ADLS. Ie. Wild cards as well

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  19. SET table

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

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    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