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. Shrinkdatabase command support

    Shrinkdatabase command should to be supported even if TDE is on or off because extra cost is charged in case that the unallocated space is huge.

    89 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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  2. Enable Intellisense With SSMS

    Intellisense is a very handy feature when using SSMS to write queries against Sql Server databases. It increases development time by reducing typographical errors.

    It would be nice to have with Sql Data Warehouse.

    83 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/Other  ·  Flag idea as inappropriate…  ·  Admin →
  3. [In preview] More flexible date formats in Polybase

    This feedback item is currently in preview here:

    https://docs.microsoft.com/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest

    Polybase currently has very limited date format support. All of the acceptable date formats have dashes or slashes. For example, I can't define a date format of yyyyMMdd since it doesn't have slashes or dashes. Please allow any date format I can express.

    Also, please allow more than one date format per external table. For example, what if I have a date column as yyyyMMdd and then a different column as yyyyMMddHHmm. With only being able to define one date format in the CREATE EXTERNAL FILE FORMAT statement I think I…

    82 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

    planned  ·  8 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  4. Restore single table from backup

    The ability to restore a single table from backup, to an existing DW, would greatly assist in recovering from errors.

    81 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/Management  ·  Flag idea as inappropriate…  ·  Admin →
  5. DROP IF EXISTS

    Support DROP IF EXISTS

    80 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

    planned  ·  0 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  6. Enable Dynamic compute - scaling up the DW should not kill any existing query

    Scaling up/down the warehouse kills all ongoing sessions.
    Adding or removing compute capacity should be truly dynamic. This means that when I add more compute - by scaling up - the DW should be able to absorb that additional compute capacity without killing existing queries.
    Maybe that compute can be brought into play for the new queries that get submitted post addition of the compute.

    Thanks,
    Mayank

    76 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/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  7. Pause Resume Azure SQL Data Warehouse Using SQL Command

    It would be great if we can have SQL command to Pause/Resume DB instance like how we do for Scale up/down (under Master DB). This will help us to manage the same from ADF and don't have to worry about trigger REST API or PowerShell

    73 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/Management  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for voting for this feature. We understand this scenario and will consider this in a future release. For now, please continue monitoring this item and have your team vote for this feature. Thank you for your patience.

  8. [In preview] Inline and Table Valued Function support

    This request is currently in Preview:
    https://docs.microsoft.com/en-us/sql/t-sql/statements/create-function-sql-data-warehouse?view=sqlallproducts-allversions

    Currently Functions can only return a single variable, but we need to be able to return full tables so we can use them within the WHERE clause.

    71 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  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  9. Resource Governance - Resource Pools - Control CPU, physical IO, memory, priority, run-time cap, max request, concurrency, request timeout..


    1. Ability to manage workloads effectively

    2. Enables to specify limits on the amount of CPU, physical IO and memory

    3. User-Defined Resource Pools
      a. Memory size
      b. Memory cap
      c. CPU
      d. Maximum requests
      e. Grant time-out
      f. Priority
      g. Concurrency
      h. Run-time cap

    70 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

    7 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  10. Table Extended Properties

    Add the ability to store table extended properties so that meta data about the table can be stored. This will help with self documentation to aid BI Developers.

    67 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

    11 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  11. Stuff.....For XML

    Please provide support for STUFF......FOR XML so we can do complex concatenation using Azure Data Warehouse. Right now its kind of show stopper for us due to time taken by workarounds (while loop).

    65 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

    under review  ·  5 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  12. Support Always encrypted in SQL Data warehouse

    Always Encrypted makes the data to be only available to client side applications and not visible to Database administrators also. It makes the data to be more secure. It is especially needed in the case of Azure, where PII data is stored in cloud.

    63 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/Security  ·  Flag idea as inappropriate…  ·  Admin →
  13. Delta lake support to SQL on Demand

    Currently, Delta lake table is not supported to be queried using SQL on Demand. Adding this functionality would help to greatly use SQL on-demand for analyzing the delta lake table.

    This will save time to query any Spark database delta lake table without spinning spark pools.

    61 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

    under review  ·  14 comments  ·  Workspace/SQL Scripts  ·  Flag idea as inappropriate…  ·  Admin →
  14. Automatic Generation and Updating of table statistic

    It would be great if table statistics were automatically created and updated in Azure Data Warehouse.

    60 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  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  15. Add support for synonyms

    CTAS to a new table is often a pattern that's used in DW for data processing workloads. Instead of RENAME OBJECT operations from old tables to the new ones using CTAS, it would be great if we can add synonym support to DW, so that switching to the new table is an atomic operation, and is reliable.

    59 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

    under review  ·  3 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add WAITFOR command to SQL Datawarehouse

    The following wont compile on ADW

    IF @count = 4

                BEGIN
    
    WAITFOR DELAY '00:30';
    SET @count = 0;
    END

    Please allow WAITFOR command on ADW

    57 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 →
  17. Support table variables

    Prior to data analysis it is required to collect some initial info and store it in a table format. Creating and dropping a table or a temp table takes too much time (seconds) since it has to be distributed over multiple nodes. Having table variables would solve this performance issue.

    57 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

    under review  ·  0 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  18. unit test framework

    The open source tsqlt framework requires CLR which is not available in Azure SQL DW. A framework to to write unit tests would increase trust in the queries.

    51 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

    6 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for your feedback folks. We are actively looking into this scenario specifically with SSDT Database Project support with SQL Data Warehouse. Please continue voting and monitoring this item for updates. Thank you for your patience.

  19. Implementing elastic pools for Azure SQL Data Warehouse

    A customer asked if there are plans to implement some sort of elastic pools where you can include many data warehouses and share DWU (eDWU?) the same way elastic database pools work with SQL Databases.

    48 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  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for all the feedback folks. This is on our radar and we will consider this in a future release. We will reach back out when it is on the roadmap and can share when we have an update. Please vote for this feature and comment on your scenario below.

  20. Polybase to treat \N as NULL (or allow custom null support)

    I was trying to load external file into SQL DW table using polybase. This external file has \N as value for null columns. For example :

    2,"C1008",1,\N,1,1,"2016-02-09 23:13:02","2014-02-21 20:11:36","2016-02-08 17:48:59","2008-07-16 14:17:40",947

    I defined external data format as below:

    CREATE EXTERNAL FILE FORMAT TextFileFormat
    WITH
    ( FORMATTYPE = DELIMITEDTEXT
    , FORMAT
    OPTIONS ( FIELD_TERMINATOR = ','

                    ,    STRING_DELIMITER = ''
    
    , USE_TYPE_DEFAULT = FALSE
    )

    );

    when i try to load this record into DW table, I am getting below error:

    Query aborted-- the maximum reject threshold (0 rows) was reached while reading from an external source: 1 rows rejected…

    47 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/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base