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. TRANSACTION support for RENAME

    Since MERGE statement is not supported, we are using CTAS for preparing the new table and using the rename operation.

    Currently we do not have the TRANSACTION support for the RENAME operations.

    When we have two rename operations we may run into inconsistent state if second statement fails.

    RENAME OBJECT FinalTable TO FinalTableOld;
    RENAME OBJECT FinalTable
    Stage TO FinalTable;

    To overcome this, we need some workaround or support for transactions.

    46 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  2. Auto-suspend and Auto-resume

    I would absolutely magic if we had something like Snowflake:
    - Automatically suspends the warehouse if no query has been issued during a fixed amount of time
    - Automatically resumes the warehouse when a query is issued

    43 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow SELECT in user defined function (UDF)

    Currently no support to do a select statement in a UDF. Get error message 105041.

    43 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Stored procedure parameter defaults

    Can we have the ability to generate default values for stored procedure parameters

    41 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

    40 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  6. Support for XML datatype

    XML datatype is not supported in ADW now.

    40 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  7. Azure Data Factory loading to Azure DWH - Polybase permissions

    When using Polybase to load into Data Warehouse via Data Factory, Control permission on the database is required for the user.
    Can this be limited to a Schema Owner, or be more granular at the database level ?

    39 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Management  ·  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…

    39 votes

    We're glad you're here

    Please sign in to leave feedback

    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. Add support for adding custom .jars to spark clusters

    Enable a way to refer and add a custom .jars when initiating a Synapse Spark cluster to enable Synapse notebooks to import from the .jars

    38 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. 'Replication' solution from sql server to sql dataware house?

    Why not implement a Sql server 'Replication' solution from sql server (on premise / Azure) to sql dataware house (on Azure)?
    It would be useful if we have a processing DB in sql server and a accumulating datawarehouse in sql datawarehouse, with not too many structural changes.

    37 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting on this feature. Please describe your scenario in the thread below. We currently have many migration solutions from SQL Server to SQL Data Warehouse such as Azure Data Factory and Redgate through the Quick Load Azure portal experience (link below). If this is a continuous replication process, we’d love to understand your hybrid scenario so please comment below.

    https://azure.microsoft.com/blog/enhanced-loading-monitoring-and-troubleshooting-experience-for-azure-sql-data-warehouse/

  11. 36 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. Enable SQL DW as data source for external tables in SQL DB

    Querying SQL DW from SQL DB via external tables currently does not work due to an implicit SET LANGUAGE statement issued by the elastic queries component. It sets the Language to N'usenglish' (not supported) vs. usenglish (supported I guess). Same for SET NUMERICROUNDABORT, set to OFF (not supported). While you can explicitly set the NUMERICROUNDABORT to ON at run-time, you cannot do SET LANGUAGE us_english on SQL DB. Maybe other issuesd are to be found but this scenario is important.

    36 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  13. Support rebuilding DW indexes with Online = ON so the table is accessible during the rebuild

    This works:
    ALTER INDEX ALL ON VulnerabilityScope REBUILD
    But, when the rebuild takes place, the entire table becomes locked from any query--even selecting one row. Users complain when the table is inaccessible during the 30 minute rebuild.

    This currently returns an error:
    ALTER INDEX ALL ON VulnerabilityScope REBUILD WITH (ONLINE = ON)
    Parse error at line: 1, column: 48: Incorrect syntax near 'ONLINE'.

    Please support rebuilding DW indexes with Online = ON

    35 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for the feedback folks. For now, you can use Alter Index reorganize as the online operation when rebuilding your CCI . We will reach out when this is on our roadmap. Please describe your scenario for this capability below and continue to vote. Thanks for your patience.

  14. Provide a way to expose the actual DWU usage (not the same as the scale setting).

    You can see what the database is scaled to i.e. DWU 200, but how do you know how much is actually being used over time. The portal display a graph of both the DWU limit and the DWU used but there is no way to programmatically monitor how much is being used.

    34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →

    We are actively improving our monitoring experience. Currently we have ‘DWU Used’ in the portal which is a blend between CPU and IO to indicate data warehouse utilization. We also have future improvements on our road map such as Query Data Store and integrating with Azure Monitor for near real time troubleshooting in the Azure portal. If anyone has any other feedback, please elaborate on your scenario on this thread. Thank you for your continued support!

  15. Support for updating statistics on a single partition

    This would increase update statistics performance for users who are currently loading data into a single partition and updating statistics afterwards.

    Otherwise with growing data size, updating statistics takes longer after every load.

    33 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  3 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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…

    33 votes

    We're glad you're here

    Please sign in to leave feedback

    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!

  17. Polybase - Give the ability to specify a file name when outputting external tables and consolidate into a single file

    Creating an external table will result in multiple files being generated in blob storage. It would be great if the multiple files could be consolidated into a single file and be able to configure the file name.

    There are multiple files that contain 0 bytes. It would be better to have a single file and be able to specify the file name.
    This would help with idempotency to delete the file if I wanted to re-create the external table.

    32 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  18. 32 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  19. Alow multiple SQL DataWarehouse instances to access the same data (.mdf files)

    This would allow an enterprise to have a Production Data Warehouse with SLAs in place while allowing a data scientist/Business user/Subject matter expert to do analytic and discovery work without impacting SLAs and without moving data (which usually is pretty large).
    At the same time it would allow for metered consumption and chargeback towards the subtenants that are conducting analytic discovery work.
    The functionality would be similar to what can already be done today with HDInsight and Azure Blob. Data in Azure blob can be independently accessed by multiple HDInsight clusters.

    32 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  20. Expose DMVs that display the actual execution plan (sqlplan) of a query on a node after the query executes

    Currently, DBCC PWD_SHOWEXECUTIONPLAN only displays the estimated query plan of the step being executed on a compute node, while the query is running. There is no way to see the actual execution plan of the query step on the node.

    This prevents us from seeing the details of the query being executed such as the stats on how many rows were estimated vs actual rows returned, or rowgroups eliminated by the ColumnStore index, or any gross under/over estimates in the row counts owing to missing/bad statistics.

    31 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Thank you for voting for this feature! We are aware of this scenario and are looking into ways of supporting this and improving our query troubleshooting experience. In the meantime, stay tuned for an update and please continue voting for this feature.

  • Don't see your idea?

Feedback and Knowledge Base