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 CROSS APPLY OPENJSON in Create Table As Select

    Currently, when using CROSS APPLY OPENJSON to create a table, this is only possible using a SELECT INTO, as shown below. This is against the documented best practice of using the Create Table As Select (CTAS) logic.

    DECLARE @sample_json AS NVARCHAR(MAX)
    SET @sample_json = N'{
    "glossary": {
    "title": "example glossary",
    "GlossDiv": {
    "title": "S",
    "ID": "SGML"
    }
    }
    }
    }'

    IF OBJECT_ID ( 'tmp.test') IS NOT NULL
    DROP TABLE tmp.test

    SELECT GETDATE() AS inserted_date, LEN(@sample_json) AS json_length, y.title
    INTO tmp.test
    FROM (SELECT 1 AS a) a
    CROSS APPLY openjson(@sample_json) x
    CROSS APPLY openjson(x.value)
    WITH (title varchar(100) ) y

    Running this…

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support of iif/choose logical function

    Azure SQL DW does not support IIF and CHOOSE logical function while SQL Server, SQL DB and SQL MI support it. It would be good to support them to reduce the gap between SQL services.

    2 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  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. Support for RETURN statement

    Add support for RETURN statement withing stored procedures. Currently, the RETURN statement looks to only be support within user-defined functions.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. xp_logininfo

    I would like to make use of Active Directory Groups for Row-Level Security.
    In order to do so I need a functionality to know to which group a login belongs to:
    1) a user logs in using AD. The user belongs to a specific group.
    2) I can use xp_logininfo to know which group that login belongs to
    3) i can use the group within a mapping table for RowLevel Security
    4) the user can see only the rows allowed to the group he belongs to

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. Replicate table command

    I would like a command that would allow us to replicate a table and wait for the replication to complete. The reason for this is that often in ETL workflows you want to make sure the table is replicated before moving on to load the next set of tables. Currently the only way to wait for this is to first trigger a replication with a SELECT TOP 1 * FROM Table and then sit and poll a system view to wait for its completion.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  6. UPDATE FROM Support

    Updates/Deletes do not support FROM clause. To update a table with values from another we need to create temporary tables (CTAS) and run loops.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  7. Ability to Call Azure Function App From Stored Procedure

    It would be great if it were possible to call an Azure Function App from a stored procedure.

    Certain functionality can be processed much faster via a Function App then via TSQL. (For example, the DW doesn't support recursive CTE; so we use a Function App as it is much faster than a TSQL WHILE loop.)

    Our work-around is still faster than the WHILE loop within SQL, but the implementation is awkward. We use a work table that has the "id" and "status" for each task that needs to be processed by the Function App. The stored procedure adds a…

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  8. Please addtrim function is very useful when loading flat file into DW and have to match named keys in the flat file with existing columns.

    Please add trim function is very useful when loading a flat file into DW and have to match named keys in the flat file with existing columns.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  9. Support the USE <db> statement

    Support the USE <db> statement like SQL Server

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. 28 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  2 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  11. Support the sp_describe_undeclared_parameters system stored procedure

    SSIS scripts often use this system stored procedure to investigate parameter types.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add WAITFOR command to SQL Datawarehouse

    The following wont compile on ADW

    IF @count = 4
    BEGIN
    WAITFOR DELAY '00:30';
    SET @count = 0;
    END

    Please allow WAITFOR command on ADW

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add support for grouping sets

    Grouping sets are a great feature for aggregating data and providing roll ups.

    This feels like a very natural use case for SQL Datawarehouse, so it would be great if it had support for this functionality.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  14. Rename a column name in SQLDW

    Scenario: We want to change the column name as it is changed in the source. And in table where we are trying to do has more than 20Billion records.
    Workaround: Since rename of column is not possible currently in SQL DW we are doing CTAS of that big table.
    Issues With Work around: It is very slow because we can’t do CTAS on entire big table in single transaction because of transaction limits and we end up doing in CTAS and with multiple insert statements . Which is very time consuming process
    ASK: Please support column Rename

    78 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  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add "DROP Partition" command

    Having drop Partition command that automatically merges the partition boundaries and removes the partition would help a lot.

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  16. Support 'AT TIME ZONE'

    To run global reporting, need to support 'AT TIME ZONE' as found in SQL Server 2016 - https://msdn.microsoft.com/en-us/library/mt612795.aspx

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

    We’ll send you updates on this idea

    4 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  17. 16 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add support for the truncate partition option

    Add support for the option to truncate a single partition in a table (as per sql azure and sql 2016).

    https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql

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

    We’ll send you updates on this idea

    0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  19. MERGE statement support

    Support the MERGE sql statement to support management of SCD1 / SCD2

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

    We’ll send you updates on this idea

    16 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  20. DROP IF EXISTS

    Support DROP IF EXISTS

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

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

SQL Data Warehouse

Feedback and Knowledge Base