Azure Synapse Analytics

We would love to hear your ideas for new features for Azure Synapse Analytics. Below, enter a new idea or upvote an existing one. The Synapse engineering team pays attention to all requests.

If instead you need a technical question answered or help, try the these options: DocumentationMSDN forum, and StackOverflow. If you need support, please open a support ticket.

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

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

    We’ll send you updates on this idea

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  2. support for TRY_CONVERT or TRY_CAST functions

    Azure SQL DW does not support tryconvert or trycast function in T-SQL. This is must needed function to validate the conversion of data types. We have custom date conversion function which uses try_convert to convert different date formats and getting on standard date format out. Please include this feature Azure SQL DW.

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

    We’ll send you updates on this idea

    6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. Use SELECT for setting variables (SELECT @MyVar = Col1, @MyVar1 = Col2 ...)

    Because we cannot do SELECT @MyVar = Col1, we are forced to utilize the same code to execute the exact same sql, to assign multiple variables.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  4. Support 'AT TIME ZONE'

    To run global reporting, need to support 'AT TIME ZONE' as found in SQL Server 2016 - https://msdn.microsoft.com/en-us/library/mt612795.aspx

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

    We’ll send you updates on this idea

    completed  ·  6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. Support for the full length of T-SQL statements that are run in an Azure SQL Data Warehouse

    The customer I’m working with is asking if there’s a way to know the full length of T-SQL statements that are run in an Azure SQL Data Warehouse instance.
    They are using sys.dmpdwexec_requests, but it truncates the query text keeping 4000 bytes.

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

    We’ll send you updates on this idea

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

    We are excited to announce that we have implemented Query Store for Azure SQL Data Warehouse. Query Store enables storing the full query text and aggregated execution statistics for all queries for a period of 7 days. You can learn more about Query Store in our blog post:

    https://azure.microsoft.com/en-us/blog/automatic-performance-monitoring-in-azure-sql-data-warehouse-with-query-store/

    Matt Usher
    Principal Program Manager
    Azure SQL Data Warehouse team

  6. 29 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support OVER (ROWS ...) SQL Syntax

    Azure SQL DWH doesn't support ROWS UNBOUNDED PRECEDING and similar RANGE inside OVER clause. This is quite painful, because it's frequently used for querying data warehouse.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  8. Feature request : Indexed Views

    Support for creating, maintaining and using indexed views (https://msdn.microsoft.com/en-us/library/ms191432.aspx) would be very benefical for increasing query performance.

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

    We’ll send you updates on this idea

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

    2 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. ALTER DATABASE SCOPED CREDENTIAL

    Currently a user cannot change the Identity and\or Secret in the DATABASE SCOPED CREDENTIALS until they drop all objects which use the credentials. I ran a quick test and confirmed that you cannot DROP a CREDENTIAL unless you first drop all DATA SOURCEs using the credential, and you cannot drop the DATA SOURCEs until you drop all FILE FORMATs with dependencies, and you cannot drop FILE FORMATs until you drop all external tables with dependencies. This is very painful for customers.

    This capability does exist within Azure SQL DB, so we ask that this be supported in Azure SQL DW.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add Checksum function.

    Implement the Checksum built-in sql function.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow user defined functions in schemas other than dbo

    If I try to create a scalar function in Azure SQL DW in a schema other than DBO I get:

    Msg 110813, Level 16, State 1, Line 41
    Invalid operation. The connection is closed.

    If I change to dbo then it succeeds.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add support for SET NOCOUNT ON|OFF

    When exporting data from SQL DW using SQLCMD the row count is always written at the end. This means that the output has to be parsed and the message stripped to import this file. It would be nice to be able to SET NOCOUNT OFF so that this message is removed. It would also be nice to support SET NOCOUNT ON as some query tools require this support in order to avoid error messages.

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base