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. Explain plan in SSMS returned as XML data type

    In SSDT if you connect a query window to Azure SQL DW and put EXPLAIN in front of a query and run it you get back an XML data type column and clicking on the XML pops open a new XML window.

    In SSMS when you do the same the column is a text column, not XML. As a result, most large explain plans get truncated because the length of a text column returned in SSMS is smaller than the length of an XML column.

    Please change EXPLAIN plan queries to return as XML data type so that it's more…

    5 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 →
  2. Need more than 4 workload management concurrency roles

    It would be good to have a few more workload management roles that would allow for greater flexibility with the bigger DWU configurations. E.g. with DWU2000 I have the choice of smallrc which is 1 concurrency slot or mediumrc which is 16. It would be nice to have a few more levels such as 2,4 and 8 in between. At the moment I am limited to 5 concurrent queries, if I need a bigger user than smallrc.

    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

    1 comment  ·  SQL/Management  ·  Flag idea as inappropriate…  ·  Admin →
  3. Run queries from Web Interface

    Installing SSMS or VS in order to be able to access Azure SQL DW is a heavy and cumbersome operation.

    Exposing a web interface to run queries will make the product much more accessible and user friendly.

    2 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 →
  4. DMV to see if autogrow is on

    Apparently there is no current DMV or command to verify whether autogrow is currently on or off. Please add such a DMV.

    2 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. sqlcmd on Linux needs to support AD authentication

    We are in the process of updating SSMS to 2016, but most of the automated, production processes we use run from Linux using SQLCMD. Our corporation dictates that all database accounts authenticate with AD (to ensure password complexity rules are enforced).

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

Feedback and Knowledge Base