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. Allow results of a Stored procedure call to be stored to a table.

    APS PDW on-Prem... I'm having to create a permanent table with session Id as part of the key to be able to pass record sets back and forth between stored procedure calls. I'd like to at least be able to declare a table variable, and populate it with the results of a stored procedure call.

    11 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 →
  2. SET TRANSACTION ISOLATION LEVEL

    Supporting "READ COMMITTED"

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

    We’ll send you updates on this idea

    planned  ·  2 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. sp_help

    Support sp_help

    9 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 →
  4. Enable Debugging für SQL DW

    We are migrating SQL Scripts written for MS SQL Server 2008 R2 which contain a lot of dynamic SQL. At this moment one of those scripts fails pointing to row 1 column 1. There is no logic in that row. Inserting print 'Step x reached' shows me, that the script fails at a part where 100 lines of a dynamic SQL are stored in a variable of type NVARCHAR(4000). I believe 4000 chars is not enough to capture this dynamic SQL. Nonetheless I would like to be 100% sure before I start re-engineering this script. When I start the debugger…

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

    We’ll send you updates on this idea

    3 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback folks. We are actively looking into this scenario specifically with VS SSDT Database Project support with SQL Data Warehouse. Please continue voting and monitoring this item for updates. Thank you for your patience.

  5. Extend SQL DOM parser

    The SQL DOM parser supports most of SQL DW. However, there are known errors with the following:
    1. CREATE TABLE AS SELECT
    2. RENAME OBJECT (eg "RENAME OBJECT mydb.dbo.Customer TO Customer1;") from MSDN https://docs.microsoft.com/en-us/sql/t-sql/statements/rename-transact-sql?view=aps-pdw-2016-au7
    3. The LABEL query hint (eg "SELECT * FROM sys.tables OPTION (LABEL = 'My Query Label');" from here https://docs.microsoft.com/en-gb/azure/sql-data-warehouse/sql-data-warehouse-develop-label

    7 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 →
  6. SET DATEFIRST to values other than 7

    Currently SET DATEFIRST allows only to set value to 7 (Sunday)
    This van be an issue when dealing with different geogrpahies where the first day of the week is supposed to be Monday, i.g.: affecting sales distribution. Please allow values other than 7 for DATEFIRST

    6 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. Multi-column IN / NOT IN subquery

    Support multi-column IN/NOT IN subquery like:

    select
    *
    from
    schema_name.table
    where
    (c1, c2) in ( select c1, c2 from schema_name.t2 )

    6 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 →
  8. Support "DATEDIFF_BIG", like Azure SQL

    pretty useful for device data (IoT), often has in sub seconds

    6 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. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. Allow DDL inside transactions (better support for devops tools)

    Allow DDL inside of a transaction.

    This would allow for greater support of testing tools, many use transactions to unit test code. (such as redgate)

    It would also provide an environment to allow atomic deployments, where any failed deployment can be rolled back. (potentially allowing flyway support, especially as Micorosoft have no source control/deployment soultion for SQL DW)

    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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

SQL Data Warehouse

Feedback and Knowledge Base