Azure Synapse Analytics

Do you have an idea or suggestion based on your experience with Azure Synapse Analytics? We would love to hear it!

Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Synapse Analytics customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Synapse Analytics 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. Diagrams in Synapse

    Implement diagrams in Synapse (like they exists in SQL DB)

    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. Allow extended properties in Synapse

    Allow the usage of extended properties in Synapse (cfr. the extended properties in SQL DB)

    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. 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.

    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 →
  4. SQL DW: Support ALTER INDEX REORGANIZE with COMPRESS_ALL_ROWGROUPS option

    ALTER INDEX ... REORGANIZE WITH (COMPRESSALLROWGROUPS = ON) is supported in Azure SQL Server, but not in SQL DW. Supporting this would allow queries to avoid having to rebuild the index when updating all rowgroups.

    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. 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 →
  6. 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.

    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. 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'{

    "glossary": {
    
    "title": "example glossary",
    "GlossDiv": {
    "title": "S",
    "ID": "SGML"
    }
    }
    }

    }'

    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 →
  8. 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.

    5 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 →
  9. 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 →
  10. 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.

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

    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. 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 →
  13. 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.

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

    We’ll send you updates on this idea

    under review  ·  2 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. 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 →
  16. 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 →
  17. 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 →
  18. Add WAITFOR command to SQL Datawarehouse

    The following wont compile on ADW

    IF @count = 4

                BEGIN
    
    WAITFOR DELAY &#39;00:30&#39;;
    SET @count = 0;
    END

    Please allow WAITFOR command on ADW

    34 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 →
  19. 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 →
  20. 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

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

    We’ll send you updates on this idea

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

Azure Synapse Analytics

Categories

Feedback and Knowledge Base