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

    It would be very nice to have something like a page with Release Notes after every update to Azure DWH.

    Now you accidentally find out that something that did not work , works.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. Azure AD Universal Authentication Integration in Visual Studio

    Organizations with MFA requirements have to use AD Universal Authentication to log into Azure SQL DB/DW. This can be done through SSMS, but support for Visual Studio would unlock more users.

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

    We’ll send you updates on this idea

    3 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  3. Display the total size of the data warehouse including snapshots/restore points and geo-backups

    Display the total size of the data warehouse including snapshots/restore points and geo-backups. This will help customer project storage costs of the data warehouse.

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

    We’ll send you updates on this idea

    completed  ·  4 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  4. Specify Time Window for Service Maintenance

    Allow customers to define a window of time during the day where any internal maintenance should be performed in order to reduce impact to users during core business hours.

    We have seen that internal upgrade/migration processes in Azure Data Warehouse can sometimes have impact on running queries (ex. performance and connection issues). If we could specify a time where impact is less likely, then it would improve the overall experience and availability.

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

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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 →
  6. 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 →
  7. Polybase to treat NULL string as Null values and not text.

    When we have files generated by third party we have little control over the file format, in our case huge data files with lots of NULL value are causing us trouble.

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

    We’ll send you updates on this idea

    4 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  8. varchar(max) with Polybase

    need support for varchar(max) with polybase

    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/Polybase  ·  Flag idea as inappropriate…  ·  Admin →

    This is currently a feature we support. We’ve recently increased the row support size to 1MB now. Generally one should avoid unnecessarily specifying a column to be max width if not necessary for performance reasons as well.

  9. Add Query Store functionality

    Same as Query Store in SQL Server 2016+
    https://msdn.microsoft.com/en-AU/library/dn817826.aspx

    It would be really helpful if we can keep track of all queries executed on the server together with corresponding CPU cycles, query plan(s), logical and physical reads, etc.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  10. DW100 for Gen2

    We like to scale to DW100 during low demand.

    The minimum DW for Gen2 is DW1000. This represents a 10x cost increase during these hours.

    We are blocked from migrating until there is a DW100 equivalent.

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

    We’ll send you updates on this idea

    4 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add more Resource Class options for Azure SQL Data Warehouse

    It would be great to be able to have additional resource class options made available for larger-scaled data warehouses.

    For example, if a process needs 4 concurrency slots to run, the max number of concurrent processes that can be run is 7 and that would be using medium resource class and scaled to DW1500 (of course it would be running under mediumrc and consuming 8 slots which is twice more than actually needed).

    It would be nice if instead I could still run at DW1000 using a resource class that consumes only 4 slots (so I could run 10 concurrent…

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

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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 →
  13. 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/Performance  ·  Flag idea as inappropriate…  ·  Admin →

    We are moving to SHOWPLAN as the model for exposing query details. We have recently released full SHOWPLAN_XML support with graphical execution plans in SSMS 17.5. You can see the blog announcement here:
    https://azure.microsoft.com/en-us/blog/unlock-query-performance-with-sql-data-warehouse-using-graphical-execution-plans/

    You can download SSMS here:
    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

  14. 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 →
  15. Allow NVARCHAR(MAX) for variables.

    Storing dynamic SQL in NVARCHAR(4000) is not enough for our use case.

    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/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestion. We have completed the first version of this feature and it has been rolled out worldwide. The following data types are now supported, NVARCHAR, VARCHAR, VARBINARY and BINARY. There are a couple of limitations in this first version. (1) PolyBase loads to these new data types will not be supported. But you will be able to load this data through other means like bcp. (2) Cluster ColumnStore tables do no yet support these data types. These data types are supported in Heap and Cluter Index Tables. 1028371

  16. Add Polybase Rejected Rows DMV

    The REJECTTYPE and REJECTVALUE settings on a Polybase External Table are very useful for managing invalid data types, but they are very limited if you're using Polybase as a data loading mechanism. In order for this to be useful, we need visibility of which rows were rejected, even if it was within the tolerance.

    I would suggest a generic system view that logged the failed row as an untyped string (or JSON/XML string if in the SQL engine rather than the Azure SQL Datawarehouse engine).

    This would read something like:

    rejectid, objectid, querydate, rejectstring

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  17. Polybase: Remove/increase row size from 32k

    Polybase is currently limited to a maximum row size of 32k. Request that this be increased by orders of magnitude.

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow Unique Index on Columns that intersect the distribution column

    If SET tables aren't available, at least allow an UNIQUE INDEX to be placed on a table if the DISTRIBUTION column is found in the columns of the UNIQUE INDEX

    For example

    Table with locationid and productid with any number of fact columns. Partition the table by productid. All the data for any productid will be on one specific distribution. Allow that distribution to enforce uniqueness on locationid + productid.

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

    We’ll send you updates on this idea

    3 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  19. Explain plan in SSMS returned as XML data type

    In SSDT if you connect a query window to Azure SQL DW and put EXPLAIN in front of a query and run it you get back an XML data type column and clicking on the XML pops open a new XML window.

    In SSMS when you do the same the column is a text column, not XML. As a result, most large explain plans get truncated because the length of a text column returned in SSMS is smaller than the length of an XML column.

    Please change EXPLAIN plan queries to return as XML data type so that it's more…

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base