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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. 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

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

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. View the Dependencies of a Stored Procedure

    In summary, sys.sqlexpressiondependencies 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.

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

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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.

    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 →
  10. 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)

    4 votes
    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 →
  11. 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.

    3 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 →
  12. 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.

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

    We’ll send you updates on this idea

    started  ·  0 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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 @samplejson AS NVARCHAR(MAX)
    SET @sample
    json = N'{

    &quot;glossary&quot;: {
    
    &quot;title&quot;: &quot;example glossary&quot;,
    &quot;GlossDiv&quot;: {
    &quot;title&quot;: &quot;S&quot;,
    &quot;ID&quot;: &quot;SGML&quot;
    }
    }
    }

    }'

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

    DROP TABLE tmp.test
    

    SELECT GETDATE() AS inserteddate, LEN(@samplejson) AS jsonlength, y.title
    INTO tmp.test
    FROM (SELECT 1 AS a) a
    CROSS APPLY openjson(@sample
    json) x
    CROSS APPLY openjson(x.value)

    WITH
    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 →
  14. 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 →
  15. Implement distinct count in materialized view

    Materialized view allows me to use DISTINCT-keyword, but it actually returns non-distinct count as a result.

    Please add support for DISTINCT-keyword in materialized views.

    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 →
  16. Stored Procedure execution status code to be stored in a variable.

    At the moment, in Azure warehouse, we cant store the execution status of a stored procedure in a variable.

    Ex.

    DECLARE @Res INT.

    EXEC @Res = dbo.usp_xyz

    It errors out with the below error.
    Msg 103010, Level 16, State 1, Line 1
    Parse error at line: 37, column: 1: Incorrect syntax near 'EXECUTE'.

    Is there any workarounds, please post.

    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 →
  17. Implement DATE_TRUNC

    Add support in T SQL for DATE_TRUNC. IT can be cumbersome to truncate a datetime to the starting minute/hour/month etc.

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

Feedback and Knowledge Base