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. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  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. 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 →
  9. View the Dependencies of a Stored Procedure

    In summary, sys.sql_expression_dependencies doesn’t return the referenced objects of stored procedure. This works for SQL Server and in the online documentation it is likely mentioned as supported scenario. Unfortunately, it is not supported at the moment. Please add this functionality.

    0 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. Support the sp_describe_undeclared_parameters system stored procedure

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

    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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. Grant DDL, DML rights with expiry date

    Some time, we need to give access on production environment for a certain time period, either its select, ddl or dml. Currently its a manual process to revoke the access or we have to develop a process and routines to revoke them. It will be good if we could provide an expiry date with the grant statement it self and DBMS engine should auto take care of expiry on that date.

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

    We’ll send you updates on this idea

    1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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 →
  20. 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 →
← Previous 1 3
  • Don't see your idea?

SQL Data Warehouse

Feedback and Knowledge Base