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