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. User Defined Retention Periods for Restore Points

    SQL DW doesn't have the capability to specify longer term retention capabilities as released for SQL DB recently. The workaround is to restore and pause. It would be great to have this capability for compliance and auditing requirements.

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

    We’ll send you updates on this idea

    29 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  2. Support for Entity Framework

    Support for Entity Framework in Azure SQL Data Warehouse would allow for greater usability in general, but it would also allow for better support of other frameworks/protocols. Specifically, we have a need to serve our data through an OData feed, and Entity Framework's deferred execution would allow us to handle OData's Query Options in a much simpler way.

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

    We’ll send you updates on this idea

    15 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  3. Support for spatial data type

    Spatial data shlould be supported by SQL Data Warehouse the same way it is supported by SQL Server.

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

    We’ll send you updates on this idea

    under review  ·  6 comments  ·  SQL/Table Structure  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow DWU to scale without interruption

    The scaling disrupts the current session, and it's often not allowable in the production. Instead, it should finish off the existing session (sqls), and scale after that. That way, the scaling up or down can be done without causing the production disruption.

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

    We’ll send you updates on this idea

    6 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Support for Recursive CTE

    It would be great if you can add support for recursive CTEs for computing hierarchical data

    132 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    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 →
  6. Expose File Properties as additional columns to load in SQL DW

    It would be helpful if some of the properties of a BLOB file could be exposed in the external table such as: Last Modified, Filename, Size. It should be optional and could be defined in the EXTERNAL FILE FORMAT definition. Each Property should be appended to the end of the result set of an external table in the order given in the definition.

    For instance, if we are loading a directory of several files we can read the filename and derive a new column. For example, we might have a directory with 20160504.csv and 20160505.csv and the contents of the…

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

    We’ll send you updates on this idea

    9 comments  ·  SQL/Loading  ·  Flag idea as inappropriate…  ·  Admin →
  7. Lower scale points for Dev/Test environments

    SQL Data Warehouse scale stepping should be much smaller (10 DWU or even 1 DWU), than 100 DWU!
    Please fix that ASAP!
    Thank you!

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

    We’ll send you updates on this idea

    11 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  8. @@ROWCOUNT Support

    Please enable @@ROWCOUNT?

    Furthermore considering that we cannot switch NOCOUNT on, then why should it be such a secret/coded mission to track the number of rows affected by the most recent snippet of code? The proposed work-around seems onerous and doesn't always work (for dynamic SQL) yet my query window still knows and always-prints the fact that it returned 15 rows to me, for example, so why can we not leverage this elementary information inside the selfsame query (?):

    SELECT SUM(rowcount) AS rowcount
    FROM sys.dmpdwsqlrequests
    WHERE row
    count <> -1
    AND request_id IN

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

    We’ll send you updates on this idea

    under review  ·  4 comments  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  9. Provide File Format to read and load JSON and XML data from Storage

    Able to read the JSON and XML file as part of external system OR provide functionality like Extractor in Data Lake analytics so we can write our own Extractor to read respective data format.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    2 comments  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  11. 78 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL/T-SQL  ·  Flag idea as inappropriate…  ·  Admin →
  12. 66 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

    62 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    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 →
  15. 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

    57 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    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.

  16. 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.

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

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL/Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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.

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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 = &#39;&#39;
    
    , 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…

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

    We’ll send you updates on this idea

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

    44 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    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.

← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base