Azure Synapse Analytics

Do you have an idea or suggestion based on your experience with Azure Synapse Analytics? We would love to hear it!

Please take a few minutes to submit your idea or vote up an idea submitted by another Azure Synapse Analytics customer. All of the feedback you share in these forums will be monitored and reviewed by the Azure Synapse Analytics engineering team. By suggesting or voting for ideas here, you will also be one of the first to know when we begin work on your feature requests and when we release the feature.

Remember that this site is only for feature suggestions and ideas! If you have technical questions please try our documentation, MSDN forum, or StackOverflow. If you need support, please open a support ticket with us.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Expand size of LABEL in query logs

    The LABEL column in the sys.dmpdwexec_requests DMV is limited to 255 characters.

    This field needs to be much larger to store rich metadata/context of some queries.

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

    We’ll send you updates on this idea

    1 comment  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  2. Allow the default language to be changed

    It does not seem possible to change the default language to anything other than English US. I would like to be ale to change the language to British. I have tried at user and db level and neither seem to be supported.

    EXEC sp_configure 'default language', 23 ;
    GO
    RECONFIGURE ;
    GO

    ALTER LOGIN [...] WITH DEFAULT_LANGUAGE=[British];

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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

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

    We’ll send you updates on this idea

    0 comments  ·  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.

  5. Persist Data dictionary to a separate database for DBA

    Persist Data dictionary to a separate database by allowing the customer to persist the DMV, which can be used by DBA for fixing performance issues

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for this feature folks. We’d like additional information before commenting on this topic. Please provide your scenario in the comments below. We currently have Query Data Store on our roadmap.

  6. Log the columns, tables, views, schemas, procedures, indices, etc used in a query

    Allow proper due diligence to be done in introducing DDL change. Some object usage is not evident in the SQL text due to semantic layers, generated SQL, etc.

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →

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

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

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow install of Linux ODBC to be automated via puppet

    Allow install of Linux ODBC to be automated via puppet. The current Microsoft SQL Server ODBC packages can't be installed via puppet as they require EULA acknowledgment. If we adopted the ADW technology, we would inevitably have to install the ODBC software on several grids of computers that host our various ETL software. Puppet installation allows the implementers of new systems to get the software automatically installed without the DBA team's intervention.

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

    We’ll send you updates on this idea

    2 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  15. Resume command completes about a minute too soon

    A resume operation and a scale operation appear to return about a minute too soon. If your automated code immediately attempts to connect to the DW as soon as the Azure CLI resume or scale operation completes you often get the error "Cannot connect to database when it is paused". A simple one minute pause usually prevents this but I would like resume or scaling operations to not return before we can actually connect to the DW.

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  16. Cancel Query in sqlcmd

    Need to be able to cancel a query running from sqlcmd (on Linux) without terminating the session as KILL 'SIDxxxxx' does

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →
  17. Space quota at schema level

    Need to be able to specify a space quota for a schema and abort current work that causes the quota to be exceeded.

    Forces user groups to be good stewards and manage their storage usage or be prevented from additional work.

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

    We’ll send you updates on this idea

    0 comments  ·  Management  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for providing for this feedback folks. We’d like additional information before commenting on this topic. Please provide your scenario in the comments below specifically which quota configuration at the schema level.

2 Next →
  • Don't see your idea?

Azure Synapse Analytics

Categories

Feedback and Knowledge Base