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. Use statement doesn't work in Synapse serverless

    This sequence of statements doesn't work, after the USE statement, the context is still on master database, anything we execute will be on master.

    Create Database NYTaxi2
    GO
    use NYTaxi2
    GO

    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 →
  2. CETAS failing on SQL On demand pool

    The following script is able to create an external table, but the select on the external table fails:

    REATE EXTERNAL TABLE weather2
    WITH (

    LOCATION='/weather2",

    DATASOURCE = demoMalta,

    FILE
    FORMAT = parquetformat

    )
    AS
    (SELECT
    top 100 *
    FROM
    OPENROWSET(
    BULK 'https://azureopendatastorage.blob.core.windows.net/isdweatherdatacontainer/ISDWeather/year=*/month=*/*.parquet',
    FORMAT='PARQUET'
    ) AS [weather]
    )

    By changing slightly the location, everything works: LOCATION='/weather2/"

    This seems a bug. The table should not be created in the first place if the select over the table will fail. The creation managed to understand the location, but the select doesn't.

    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 →
  3. Cost Control for on Demand Mode

    On demand pool is very interesting, I have a lot of use cases in Production, But I need a cost control in place, having the option to limit how much size Query I can do by day.

    Currently, it is scary to use it in production and not knowing how much it will cost at the end of the Month

    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 →
  4. Stored procedure support for On-Demand SQL

    Currently Synapse On-Demand SQL doesnt support stored procedures. In case the On-Demand logic is to be operationalized or used from Synapse Orchestrate\ADF, it will be helpful to have stored procedures instead of copying data between external tables or building views combining different files.

    10 votes

    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

    completed  ·  2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow CosmosDB linked data to be queried from SQL on-demand

    It would be really awesome to be able to query CosmosDB linked data using SQL on-demand! (too bad this isn't aready possible at this moment with synapse-link in preview).

    Please add this feature.

    11 votes

    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

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

    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

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. DW100 for Gen2

    We like to scale to DW100 during low demand.

    The minimum DW for Gen2 is DW1000. This represents a 10x cost increase during these hours.

    We are blocked from migrating until there is a DW100 equivalent.

    10 votes

    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

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

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

    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 →
  10. Release Notes

    It would be very nice to have something like a page with Release Notes after every update to Azure DWH.

    Now you accidentally find out that something that did not work , works.

    24 votes

    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 →
  11. Challenges with backups

    When backups are running, cannot run queries.

    3 votes

    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 →
  12. 58 votes

    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

    2 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  13. sql server 2016 polybase data lake store

    On prem Polybase should support Azure Data Lake Store and push down query to Azure Data Lake Analytics

    0 votes

    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 →
  14. 29 votes

    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

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add more Resource Class options for Azure SQL Data Warehouse

    It would be great to be able to have additional resource class options made available for larger-scaled data warehouses.

    For example, if a process needs 4 concurrency slots to run, the max number of concurrent processes that can be run is 7 and that would be using medium resource class and scaled to DW1500 (of course it would be running under mediumrc and consuming 8 slots which is twice more than actually needed).

    It would be nice if instead I could still run at DW1000 using a resource class that consumes only 4 slots (so I could run 10 concurrent…

    10 votes

    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

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

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

    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 →

    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

  18. Add Split_part function to SQL DW

    Just enable what's already in SQL (STRINGSPLIT) - it's the closest I've found to Redshift SPLITPART.

    29 votes

    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

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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

    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

    2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add Polybase Rejected Rows DMV

    The REJECTTYPE and REJECTVALUE settings on a Polybase External Table are very useful for managing invalid data types, but they are very limited if you're using Polybase as a data loading mechanism. In order for this to be useful, we need visibility of which rows were rejected, even if it was within the tolerance.

    I would suggest a generic system view that logged the failed row as an untyped string (or JSON/XML string if in the SQL engine rather than the Azure SQL Datawarehouse engine).

    This would read something like:

    rejectid, objectid, querydate, rejectstring

    8 votes

    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 →
← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base