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. [In Preview] MERGE statement support

    Support the MERGE sql statement to support management of SCD1 / SCD2

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    started  ·  6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. [In Preview] Hash distribute fact table on multiple columns

    A large fact table often has multiple join keys to multiple dimension table, so while it can be opitmised for one join it always creates data movement for other joins. The hash distribution should accept multiple columns so all joins are optimised and create no data movement for dimension joins.

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

    We’ll send you updates on this idea

    5 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  4. Inline and Table Valued Function support

    Currently Functions can only return a single variable, but we need to be able to return full tables so we can use them within the WHERE clause.

    68 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 →
  5. Resource Governance - Resource Pools - Control CPU, physical IO, memory, priority, run-time cap, max request, concurrency, request timeout..


    1. Ability to manage workloads effectively

    2. Enables to specify limits on the amount of CPU, physical IO and memory

    3. User-Defined Resource Pools
      a. Memory size
      b. Memory cap
      c. CPU
      d. Maximum requests
      e. Grant time-out
      f. Priority
      g. Concurrency
      h. Run-time cap

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

    We’ll send you updates on this idea

    7 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  6. Automatic Generation and Updating of table statistic

    It would be great if table statistics were automatically created and updated in Azure Data Warehouse.

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

    We’ll send you updates on this idea

    5 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support for Large Objects in External Tables

    While you can read and write to blob storage with large objects like varchar(max) now you can't read them via external tables.

    E.g. If you define a field with varchar(max) in an external table you can't use it you need to use BCP or SSIS to get it into a physical table that is a heap or supported indexed table.

    Msg 102048, Level 16, State 1, Line 56
    Columns with large object types are not supported in external tables.

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

    We’ll send you updates on this idea

    17 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  8. Resource class override

    Having a fixed resource class assigned to a user is too rigid. Most queries can be executed efficiently with a small resource class, but certain operations (e.g. rebuild index) should be run with a larger RC. I need to switch between several user accounts just to be able to have appropriate resources for whatever operation or query I need to run. Users assigned to xlargerc can only execute a single query at a time.

    Would be great to be able to set/change the resource class used for executing each statement. Alternatively, being able to execute as a different user could…

    38 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 →

    We announced workload isolation via workload groups for public preview at Ignite in Nov., 2019. Workload groups allow you to create your own custom resource classes (among other things). Check out workload classification that allows you to assign requests by more than just login information too!

  9. Support EXECUTE AS for stored procedures

    As part of the ELT procedure the user staging data should be able to call a transform procedure to ingest the data without having read/write permissions to the production tables.

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

    We’ll send you updates on this idea

    4 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  10. Better Database & Query Monitoring through Azure Portal

    Enable a better experience when it comes to monitoring and analysis of queries and DWH/query performance. Currently the SQL DW blade in the Azure Portal does only show very basic information about queries and their execution as well as DTUs with no possibility to customize the charts or the (query) lists. Only the last 50 queries are shown in this list, there are no overall reports and statistics (long running queries), there is no possibility to filter this list or show other metrics. Please enable a similar experience for monitoring of query and DB performance like SQL DB offers (Query…

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →

    We are actively improving our monitoring experience. We have future improvements on our road map such as Query Data Store and integrating with Azure Monitor (logs and metrics) for near real time troubleshooting in the Azure portal. If anyone has any other feedback, please elaborate on your scenario on this thread and have your team continue to vote. Thank you for your continued support!

  11. Allow CosmosDB linked data to be queried from SQL on-demand

    It would be really awesome to be able to query CosmosDB linked data using SQL on-demand! (too bad this isn't aready possible at this moment with synapse-link in preview).

    Please add this feature.

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  12. Assign a private IP from VNET

    The current VNET endpoint solution does not allow connections via expressroute.

    Allow a private IP from the VNET to be assigned to the data warehouse, so that we can easily route to the warehouse from on prem, via expressroute. Removing the need for any complex peering or other IT infrastructure involvement.

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

    We’ll send you updates on this idea

    started  ·  0 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support "DATEDIFF_BIG", like Azure SQL

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

    9 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 →
  14. 7 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 →
  15. Stored procedure support for On-Demand SQL

    Currently Synapse On-Demand SQL doesnt support stored procedures. In case the On-Demand logic is to be operationalized or used from Synapse Orchestrate\ADF, it will be helpful to have stored procedures instead of copying data between external tables or building views combining different files.

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

    We’ll send you updates on this idea

    started  ·  1 comment  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

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

    We’ll send you updates on this idea

    started  ·  0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  18. challenges with concurrency model

    Challenges with concurrency model
    o The partner would like more control on how many concurrency slots a query has
    o The partner suggests that the concurrency slot choices are too limiting (1,2,4,8,16,32,64). They would like to choose the number of slots 1-80
    o The partner would like to be able to dynamically change the number of slots - or have the system dynamically change for them
    o An example of the rigidity is if the partner has 2000 DWUs - and thus 80 concurrency slots - and they have a large query running taking 64 slots, another large query would…

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    We announced workload isolation with workload groups for preview at Ignite Nov., 2019. Workload groups allow you to specify a decimal amount of resources per request. There is no notion of concurrency slots anymore.

  19. CONCAT_WS

    Add CONCAT_WS in Azure SQL DW. It exists in SQL Azure but not in Azure DW.

    5 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 →
  20. [In Preview]Support column level encryption and decryption based on security rules.

    At this time Synapse warehouse does not support or give a method to decrypt a single column based on algorithm like AES.
    The idea is I should be able to encrypt sensitive columns in a file (bolb) outside of the database load it as is to warehouse. Once loaded I can define rules for each user and provide feature like decrypt the column if the user is allowed by fetching key from Key vault else show encrypted value for data protection.

    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  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base