Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more here.

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. Add code formatting functionality for SQL

    Add code formatting feature to the editor, similar to VS Code or Azure Data Studio.

    1 vote

    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

    0 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  2. Password expiry option

    Hi Team,

    SQL DW and SQL DB should have password expiry option.
    As of now password never expires. Please implement password expiry.
    It is one of the compliance requirement in Philips.

    1 vote

    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

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

    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

    0 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  4. full back up frequency

    I would like to be able to do full back ups more frequently than once a day.

    1 vote

    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. Scaling of ADW or Azure Database and Cost incurred

    We should have report on Azure portal which shows performance level of ADW or Azure Database with respect to time stamp and Cost incurred for that period.

    With this report we should get cost incurred for a particular instance and duration the instance was in different performance level for a period.

    This helps in financial planning for future depending upon the trend of cost incurred for that instance.

    1 vote

    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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. exception of fire wall rule by trusted Azure Service

    We should need a exception of fire wall rule that allows accessing from trusted Azure Service same as Storage Account.

    1 vote

    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

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

    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

    0 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  8. Full and simple integration between azure Datalake and azure DW with the notebooks running in any VM machine, Linux or Windows.

    Full and simple integration between azure Datalake and azure DW with the notebooks. Support for commom database connection drivers like pyodbc. And the most import, simple way to use Azure Active Directory log in to DW and Data Lake using Windows or Linux VM !

    1 vote

    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

    0 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  9. Unload data using COPY INTO

    We would like to synapse to support also unloading data using copy into statement. This is supported in Snowflake and Redshift.
    https://docs.snowflake.net/manuals/user-guide/data-unload-azure.html#unloading-data-directly-into-an-azure-container

    1 vote

    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

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  10. DMA for migrating Azure SQL Database to Azure SQL Data Warehouse

    Can you add Azure SQL Data Warehouse as one target and Azure SQL Database as one source in Microsoft Database Migration Assistant software?

    1 vote

    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

    0 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  11. Allow OPENROWSET query to ADLS2 files

    It would be nice to be able to use T- SQL syntax such as OPENROWSET etc. in SSMS or Azure Data Studio to query Azure Data Lake Storage files.

    1 vote

    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

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. Correct USE_TYPE_DEFAULT= FALSE rules for UTF-16 External file formats

    External file formats with UTF-16 encoding are not obeying the USETYPEDEFAULT= FALSE logic and are converting NULL marks in flat files to USETYPEDEFAULT = TRUE logic. There appears to be some kind of implicit conversion to UTF-8 causing NULL marks to no longer correctly appear.

    1 vote

    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

    0 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  13. can you please included dynamic folder names(.I.E wild cards)

    can you please included dynamic folder names(.I.E wild cards)

    1 vote

    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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Pricing issue/confusion on MS site

    This has been now renamed to Azure Synapse Analytics. I see a surprising change in pricing. Compute cost of all Gen 2 services is same irrespective of the configuration. e.g. - DW100c costs same as DW30000c

    Either someone messed up with the site while pushing updates or there is some reasoning behind it which I cannot comprehend. Can some one advise why is that happening? Screenshot attached for reference

    1 vote

    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/Other  ·  Flag idea as inappropriate…  ·  Admin →
  15. label query syntax not working in azure sql dw

    label query not working in sqldw

    SELECT * FROM sys.dmexecrequests r WHERE r.[label] = 'My Query Label' ; (is it correct sql documented in label)

    1 vote

    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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. evaluate table structure for queries at table level (select count(*))

    Polybase does not evaluate datatypes for queries at table level like "select count()". When a numeric field contains alpha numeric data the record is not rejected when you use "select count()", but it is when you use "select *". It will be great when this is consistent.

    1 vote

    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

    0 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  17. Please enable the ability to read audit files in ADW

    There is no counter part to the system function sys.fngetaudit_file (Azure and on premise SQL Server) in ADW. Please enable it to read audit files in ADW.

    1 vote

    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

    0 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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

    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

    0 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  19. Error File Logging For All Major Formats

    Currently in order to use the error file functionality CSV format must be used.

    The main issue is that using other formats like parquet, ORC, etc. no detailed information about load errors can be captured (row #, column #, exact values). In most of these scenarios the error message returned is also too generic to even guess the row/column causing issues.

    The standard suggestions to convert to CSV makes debugging data load issues complex because changing the file format actually can eliminate the underlying issues, or in some cases introduce new issues, because the formats are treated differently.

    1 vote

    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

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Access to ADLA catalogs using Polybase

    It will be nice if we can access ADLA catalogs using Polybase , we can theoretically eliminate the process of ELT . Please share your thoughts .

    1 vote

    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

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

Feedback and Knowledge Base