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. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  4. 29 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. [In preview] Database project from Visual Studio to support Azure SQL Data Warehouse

    Database project from Visual Studio is useful to manage DDLs, schema compare between the project and database, etc. Please create a project template dedicated for DW or support DW development from Database Project.

    Download the Visual Studio 2019 preview here: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-install-visual-studio

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

    We’ll send you updates on this idea

    105 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  7. Support 'AT TIME ZONE'

    To run global reporting, need to support 'AT TIME ZONE' as found in SQL Server 2016 - https://msdn.microsoft.com/en-us/library/mt612795.aspx

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

    We’ll send you updates on this idea

    completed  ·  6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  8. ANSI joins support in UPDATE & DELETE statement

    SQL DW does not support to usual way of joins (ANSI) in UPDATE, DELETE statement. This makes difficult in case of table data modification. Though there is a workaround provided for CTAS this seems to be a lengthy process of data modification. Please have this feature available in SQL DW.

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

    We’ll send you updates on this idea

    3 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add support of JSON format

    Please add support of JSON data format like just happened for SQL Server 2016 and Azure SQL Database with JSONVALUE, JSONQUERY, etc.

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

    We’ll send you updates on this idea

    6 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  10. 120 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  11. support for TRY_CONVERT or TRY_CAST functions

    Azure SQL DW does not support tryconvert or trycast function in T-SQL. This is must needed function to validate the conversion of data types. We have custom date conversion function which uses try_convert to convert different date formats and getting on standard date format out. Please include this feature Azure SQL DW.

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

    We’ll send you updates on this idea

    6 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. Allow Unique Index on Columns that intersect the distribution column

    If SET tables aren't available, at least allow an UNIQUE INDEX to be placed on a table if the DISTRIBUTION column is found in the columns of the UNIQUE INDEX

    For example

    Table with locationid and productid with any number of fact columns. Partition the table by productid. All the data for any productid will be on one specific distribution. Allow that distribution to enforce uniqueness on locationid + productid.

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

    We’ll send you updates on this idea

    3 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  13. Feature request : Indexed Views

    Support for creating, maintaining and using indexed views (https://msdn.microsoft.com/en-us/library/ms191432.aspx) would be very benefical for increasing query performance.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  14. Row-Level Security

    It would be great to implement Row-Level Security on SQL Data Warehouse.
    That would be a great solution for scenarios where (for example) we have clients like PowerBI using data from SQL warehouse, and persons who have limited data access.

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

    We’ll send you updates on this idea

    5 comments  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  15. PolyBase: allow retrieving rejected rows in an error file

    Let's say you define an external table with:

        REJECT_VALUE = 1000,
    
    REJECT_TYPE = value

    That means that it can reject and discard 1000 rows without failing the entire command.

    Please enhance Polybase to give us visibility into which rows were rejected and why. I would propose you can define an error output file where rejected rows get written. Either that or let us query some DMV to get a copy of the complete row as a string and the error reason.

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

    We’ll send you updates on this idea

    14 comments  ·  SQL/Polybase  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add XP_LoginInfo (for APS)

    With OLTP SQL, the command xp_logininfo helps mapping out security and would be helpful in APS.

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Security  ·  Flag idea as inappropriate…  ·  Admin →
  17. Display the total size of the data warehouse including snapshots/restore points and geo-backups

    Display the total size of the data warehouse including snapshots/restore points and geo-backups. This will help customer project storage costs of the data warehouse.

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

    We’ll send you updates on this idea

    completed  ·  4 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Challenges with backups

    When backups are running, cannot run queries.

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

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base