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. 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 →
  2. sort a columnstore on CTAS/rebuild

    Columnstores can eliminate segments based on the min/max vaules of a column.

    For best performance, the data would need to be sorted by the users desired column, such as a date.

    See - http://www.nikoport.com/2014/04/16/clustered-columnstore-indexes-part-29-data-loading-for-better-segment-elimination/

    I'd love to see a syntax that looks something like the below (but without the need for creating a clustered index first)

    with
    (

    DISTRIBUTION = hash ( [store] ),
    
    clustered columnstore index (order by DateStamp)

    )

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow Bulk insert from blob storage

    Due to the limitations currently in polybase its not an option for a lot of data sources. It would be great to be able to use bulk insert off blob storage like what is enabled in Azure SQL database as an option at least in the meantime.

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

    We’ll send you updates on this idea

    2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  4. More Collation support + ability to set via the Portal

    Right now according to the documentation the only options for collation on SQL Data Warehouse are "The default collation is SQLLatin1GeneralCP1CIAS. The other collation option is Latin1General100CIASKS_WS."

    We run Latin1GeneralCI_AS which I suspect a large amount of UK customers would do. This is a supported Collation as per SQL Azure which we are migrating our operational datastore to but we can't move our data warehouse because of this. Also like SQL Azure can we have this as an option via the management portal when we create a DW.

    4 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 →
  5. Allowing user to use local timezone is very necessary, it's not easy for users to change their programs to meets UTC timezone.

    Allowing user to use local timezone is very necessary, it's not easy for users to change their programs to meets UTC timezone.

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Challenges with backups

    When backups are running, cannot run queries.

    3 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 →
  7. Change - Exclusive lock queries wait until all select queries are complete

    Exclusive locks wait until all the select queries on the tables are completed.Instead if an option is given to switch between locking mechanism (i.e either use FIFO locking mechanism or the current locking mechanism)

    3 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 →
  8. Expose Explain Plan XML Schema

    In order to build up tooling around the Explain Plan output having the XML Schema published and versioned is key. By having access to the schema, it will allow for integrator and ISV partners to know the shape of XML and properties contained in it.

    This will allow for easier integration to allow for processing etc. of the XML to help DW Users derive insight from the content of the Explain operation.

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

    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

  9. Need data encryption and decryption support for data at rest in Parallel Data Warehouse

    Parallel data warehouse does not support data encryption and decryption at rest as in previous version of SQL Server. it is very difficult to go with PDW if we are in the position to process PII data. It is necessary to add cryptography feature to make PDW as more secured system for storing data at rest. Even though the cryptography can made through external component (ie., .Net code) the performance will be the question when deal with massive records.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  10. Need more than 4 workload management concurrency roles

    It would be good to have a few more workload management roles that would allow for greater flexibility with the bigger DWU configurations. E.g. with DWU2000 I have the choice of smallrc which is 1 concurrency slot or mediumrc which is 16. It would be nice to have a few more levels such as 2,4 and 8 in between. At the moment I am limited to 5 concurrent queries, if I need a bigger user than smallrc.

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  11. Expose Clustered ColumnStore Trim reason via DMV sys.dm_db_column_store_row_group_physical_stats for debugging purposes

    We're seeing in our DMVs that our Clustered ColumnStore indexes have less than 1M rows in a COMPRESSED RowGroup (200K-300K) However, there is no way to tell the TRIM_REASON for this, whether its based on memory pressure (lower resource class used when creating the CCI) or dictionary size overflows because of high cardinality of data in some columns or something else.

    We need support for the DMV sys.dmdbcolumnstorerowgroupphysical_stats in SQL DW as well.

    2 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 →
  12. Run queries from Web Interface

    Installing SSMS or VS in order to be able to access Azure SQL DW is a heavy and cumbersome operation.

    Exposing a web interface to run queries will make the product much more accessible and user friendly.

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  13. DMV to see if autogrow is on

    Apparently there is no current DMV or command to verify whether autogrow is currently on or off. Please add such a DMV.

    2 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 →
  14. Support defining external data source as a public blob

    We would like Polybase to support a public blob as an external data source. This should not require any credentials. The benefit is that for public datasets already stored on a Azure public blob, I can directly reference it in SQL DW and import that into the data warehouse without making another copy to my own private blob.

    2 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 →
  15. 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 →
  16. When will the upgrade to the latest version of Azure DW be available in the North Europe region?

    When will the upgrade to the latest version of Azure DW be available in the North Europe region?

    1 vote
    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 →
  17. sqlcmd on Linux needs to support AD authentication

    We are in the process of updating SSMS to 2016, but most of the automated, production processes we use run from Linux using SQLCMD. Our corporation dictates that all database accounts authenticate with AD (to ensure password complexity rules are enforced).

    1 vote
    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 →
  18. Add XP_LoginInfo (for APS)

    With OLTP SQL, the command xp_logininfo helps mapping out security and would be helpful in APS.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  19. Unable to see objects in object explorer

    We are unable to see list of objects using SSMS (any version). This would be require to navigate through database objects.

    1 vote
    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 →
  20. collect the Price per Hour in Azure Portal relate the region.

    In Japan West, The price per hour 100DWU is $0.98/hour,
    But In Azure Portal' Azure SQL Data Warehouse - scale,
    The price per hour 100DWU show $0.70/hour.

    I want to know collect price / hour.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base