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 the session language to be changed

    When setting the session language to Japanese when connecting to the Synapse, got an error 'Only 'us_english' or 'English' language is supported by SQL Server Parallel DataWarehousing TDS endpoint.'.

    2byte characters will be converted to '?', so please support the
    session language setting.

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  2. version tracking and release notes

    Currently there is no way to know the version number of the datawarehouse by running either select @@version or SELECT SERVERPROPERTY('ProductVersion'). These will give you the same values such as "10.0.11115.0" even after multiple upgrades and are not useful for tracking purposes. Can you please add a functionality to that returns the proper version and build numbers? Also the release notes provides only feature enhancements but not bug fixes, if you can add bug fixes in the following location, that would be fantastic as well - https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/release-notes-10-0-10106-0

    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 →
  3. User Defined Retention Periods for Restore Points

    SQL DW doesn't have the capability to specify longer term retention capabilities as released for SQL DB recently. The workaround is to restore and pause. It would be great to have this capability for compliance and auditing requirements.

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

    We’ll send you updates on this idea

    31 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  4. Enable support for cross subscription restore

    The current workaround for cross subscription restore is:


    1. Restore to a new logical server in the same prod subscription

    2. ‘Move’ the new logical server with the restored data warehouse to new subscription

    It would be faster and simpler to enable restore directly to a different subscription.

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

    We’ll send you updates on this idea

    10 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  5. Enable SSMS to script CREDENTIALS for SQL Data Warehouse like SQL Database

    SQL Server Management Studio shows a folder for Database Scoped Credentials in case of an SQL Database but not in case of SQL Data Warehouse.

    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 →
  6. Support for tracking deadlock in SQLDW

    Currently SQLDW doesn't have option to track deadlocks. It would be good if that option is available in Azure Portal as like SQL Database

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

    23 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 →
  8. SSDT Visual Editor Support

    SSDT Visual Table editor is disabled with Synapse. Please add support for this feature. This is one of the reasons to use SSDT over SSMS for development.

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  9. extend the backup retention period to 35 days for our SQL DW

    How to extend the backup retention period to 35 days from 7 days for our SQL DW / MS product group team could you please help on this

    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 →
  10. Export Restore Point to Blob storage for Long term backups or migrating data

    To be able to export a Restore Point to Blob Storage to meet Compliance data retention policy's, and be able to restore a warehouse from the blob data set. We are on legal hold and not allow to delete backups at this time and the only way to meet this requirement is to export the each table to blob.

    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 →
  11. Shrinkdatabase command support

    Shrinkdatabase command should to be supported even if TDE is on or off because extra cost is charged in case that the unallocated space is huge.

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

    We’ll send you updates on this idea

    2 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  12. Restore single table from backup

    The ability to restore a single table from backup, to an existing DW, would greatly assist in recovering from errors.

    62 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 →
  13. AutoPause after user-defined inactive period

    Especially in dev environments, a currently running dw with no active queries is a waste. Some guard rails to protect users from themselves would be useful.

    Something like the feature in databricks.

    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 →
  14. Add ActiveQueryCount to REST API property outputs

    Provide ActiveQueryCount as a result output under .properties for the REST API database state parameter.

    https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-rest-api

    {

    "sku": {
    
    "name": "DataWarehouse",
    "tier": "DataWarehouse",
    "capacity": 900
    },
    "kind": "v12.0,user,datawarehouse,gen2",
    "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 263882790666240,
    "status": "Paused",
    "databaseId": "e6f5193e-f0f1-4a26-a9b3-66a66bf12e20",
    "creationDate": "2019-06-27T14:50:12.197Z",
    "currentServiceObjectiveName": "DW100c",
    "requestedServiceObjectiveName": "DW100c",
    "defaultSecondaryLocation": "centralus",
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "readScale": "Disabled",
    "readReplicaCount": 0,
    "currentSku": {
    "name": "DataWarehouse",
    "tier": "DataWarehouse",
    "capacity": 900
    },
    "storageAccountType": "GRS"
    },
    "location": "eastus2",
    "tags": {},
    "id": "/subscriptions/eaab21d5-8ecd-4ef0-a0c4-92fac2e22875/resourceGroups/dw/providers/Microsoft.Sql/servers/hiramdw/databases/dw",
    "name": "dw",
    "type": "Microsoft.Sql/servers/databases"

    }

    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 →
  15. Allow both primary and secondary maintenance to be scheduled on Saturday and Sunday

    Primary and Secondary maintenance must be mutually exclusive (either Saturday / Sunday or during weekdays); We run batch jobs daily, with the exception of Saturday. Must schedule maintainance on Saturday.

    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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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 →
  17. 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

    64 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 →
  18. Ensure all billable metrics are viewable in the Azure portal

    Ideally all billable components of a Data Warehouse should be visible via the Azure Portal.

    We had a client recently who was trying to reconcile their billing, and could not do so as the DW size did not appear in the portal. This then required the DBA team to retrieve the size via the client admin tools: https://docs.microsoft.com/en-us/sql/relational-databases/databases/display-data-and-log-space-information-for-a-database?view=sql-server-2017

    Trending on billable metrics potentially also helps customers forecast their upcoming Azure costs.

    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 →
  19. sp_send_db_mail needs to be supported to send mails from stored procedure

    spsenddb_mail needs to be supported to send mails from stored procedures created on Azure.

    We should have the abilities of spsenddbmail which was available with databases

    8 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 →
  20. sys.dm_db_stats_properties

    Implement the sys.dmdbstatsproperties DMV to expose the modctr to get a better idea of when stats should be updated. using stats_date isn't a complete solution. as you have no idea if any rows have changed since that date

    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 →

    Thank you for all the feedback folks. We are continuously improving the manageability experience with SQL Data Warehouse which includes automatic statistics. We will reach back out when this is on the roadmap and can share when we have an update.

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base