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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. Add "DROP Partition" command

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

    22 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. 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 →
  7. 23 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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

    15 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. Not to be locked at CREATE / DROP USER

    If you execute CREATE / DROP USER during updating query execution, a wait occurs when trying to acquire an exclusive lock.

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

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

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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.

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

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

    Support sp_help

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

    We’ll send you updates on this idea

    5 comments  ·  T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  15. column default

    Support column default with expression. (E.g. Getdate())

    19 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 →
  16. DROP IF EXISTS

    Support DROP IF EXISTS

    57 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 →
  17. 73 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 →
  18. @@ROWCOUNT Support

    Please enable @@ROWCOUNT?

    Furthermore considering that we cannot switch NOCOUNT on, then why should it be such a secret/coded mission to track the number of rows affected by the most recent snippet of code? The proposed work-around seems onerous and doesn't always work (for dynamic SQL) yet my query window still knows and always-prints the fact that it returned 15 rows to me, for example, so why can we not leverage this elementary information inside the selfsame query (?):

    SELECT SUM(rowcount) AS rowcount
    FROM sys.dmpdwsqlrequests
    WHERE row
    count <> -1
    AND request_id IN

                    (   SELECT
    102 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 →
  19. Support "DATEDIFF_BIG", like Azure SQL

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

    8 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. ANSI joins support in UPDATE & DELETE statement

    SQL DW does not support to usual way of joins (ANSI) in UPDATE, DELETE statement. This makes difficult in case of table data modification. Though there is a workaround provided for CTAS this seems to be a lengthy process of data modification. Please have this feature available in SQL DW.

    126 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 →
  • Don't see your idea?

Azure Synapse Analytics

Categories

Feedback and Knowledge Base