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

  2. TRANSACTION support for RENAME

    Since MERGE statement is not supported, we are using CTAS for preparing the new table and using the rename operation.

    Currently we do not have the TRANSACTION support for the RENAME operations.

    When we have two rename operations we may run into inconsistent state if second statement fails.

    RENAME OBJECT FinalTable TO FinalTableOld;
    RENAME OBJECT FinalTable
    Stage TO FinalTable;

    To overcome this, we need some workaround or support for transactions.

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  3. Availability Zones - Introduce a high availability option for SQL DW

    If a high availability option would be introduced for SQL DW, it would benefit customers like us, who are using the service to run business critical applications.

    Currently there are too many potential time windows for maintenance breaks and it would be great if there would be no need to worry about those interfering with production. Perhaps a similar option could be introduced, as for SQL DB?

    7 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/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  4. Once a proc is executed and if we try to stop it, its not working. Sometimes it takes 6-8 hours to get it cancelled

    Once a proc is executed and if we try to stop it, its not working. Sometimes it takes 6-8 hours to get it cancelled

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  5. Allow enforced uniqueness of primary keys.

    Without this option, it is very difficult (and time consuming) to be certain that the data in Synapse is reliable. This is not acceptable for an enterprise solution.

    See this link for a description of the problem:
    https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-table-constraints

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  6. Synapse Analytics Maintenance

    Currently Synapse Analytics instances below DWC400c are not notified of maintenance and maintenance schedules can not be created for instances DWC400c and under.

    Allow all levels to have maintenance performed within maintenance schedule.

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

    We’ll send you updates on this idea

    0 comments  ·  SQL/Reliability  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base