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. Expose Spark Pools through Open Components like Yarn Queues so External Tools Can Integrate

    All ETL tools commercial and OpenSource on the market today can speak to Spark instances. With Synapse, Microsoft seems to want to completely wall off outside techs from making use of the infrastructure. I'm not quite understanding what Microsoft has against other tools interacting with infrastructure. HDInsights is dead (don't @me, we all see it), Databricks seems to be on the outs, (why would MS build a 3rd "Spark" platform) and the 2nd in the row (DB is fine so long as you stay within the walled garden) that is trying to crowd out 3rd party tools.

    Please make it…

    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  ·  Workspace/Spark/.NET for Spark  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add a way to natively expose an OData layer

    A common need is to expose a database through a configurable OData layer. Azure Synapse Analytics is just different enough from TSQL where traditional tools don't really work. Writing a simple app using Entity Framework doesn't even work with ASA as a few important keywords (like OFFSET) are unsupported.

    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 →
  3. Flatten control flow diagram for conditionals in orchestrate

    Currently, creating an "if condition" activity means nesting the conditionally executed tasks inside the if-activity. This makes making changes to the control flow quite cumbersome, Preferable it would be possible to drag lines to to control the order of conditionally executed tasts. "If True" gets the green line and "If False" gets the red line. This is how we would white board it in a meeting, and it is more efficient, considering you can otherwise not re-use activities that are nested in a conditional.

    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  ·  Workspace/Management  ·  Flag idea as inappropriate…  ·  Admin →
  4. Queries to allow for maintenance and performance related metada from Azure.

    We need to be able to cross reference executed queries in the database with issues such as DWU level, CPU, Maintenance Window... etc. For example if I execute a query to view historical queries, there is no valid comparison unless I show the level of the DWU as well at each particular time. If there were 200 executions, this would take a long time.

    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 →
  5. Queries to allow for maintenance and performance related metada from Azure.

    We need to be able to cross reference executed queries in the database with issues such as DWU level, CPU, Maintenance Window... etc. For example if I execute a query to view historical queries, there is no valid comparison unless I show the level of the DWU as well at each particular time. If there were 200 executions, this would take a long time.

    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. Azure Synapse Analytics on-premises

    Hi, looking for technologies that answer to high requirements in terms of security and analytics, and wondering if it would make sense to enable Azure Synapse Analytics on-premise ? We are seeing some trends of cloud solutions reverting to become hybrid. What about this solution ? Thanks.

    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 →
  7. Add default format with timezone in external file formats

    As described here https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-file-format-transact-sql?view=azure-sqldw-latest, none of the default acceptable datetime formats supported in an External file have timezone support.
    When DATE_FORMAT isn't specified or is the empty string, PolyBase uses the following default formats:
    • DateTime: 'yyyy-MM-dd HH:mm:ss'
    • SmallDateTime: 'yyyy-MM-dd HH:mm'
    • Date: 'yyyy-MM-dd'
    • DateTime2: 'yyyy-MM-dd HH:mm:ss'
    • DateTimeOffset: 'yyyy-MM-dd HH:mm:ss'
    • Time: 'HH:mm:ss'

    Requirement:
    Add at least one timeformat in list of default acceptable datetime formats so that datetimeoffset columns can be used along with other datetime types in a single external file.

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

    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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base