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: Documentation, MSDN forum, and StackOverflow. If you need support, please open a support ticket.

Suggest an idea for a new or improved feature!

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

  1. [In preview] Database project from Visual Studio to support Azure SQL Data Warehouse

    Database project from Visual Studio is useful to manage DDLs, schema compare between the project and database, etc. Please create a project template dedicated for DW or support DW development from Database Project.

    Download the Visual Studio 2019 preview here: https://docs.microsoft.com/azure/sql-data-warehouse/sql-data-warehouse-install-visual-studio

    951 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    105 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →

  2. Stored procedure support for On-Demand SQL

    Currently Synapse On-Demand SQL doesnt support stored procedures. In case the On-Demand logic is to be operationalized or used from Synapse Orchestrate\ADF, it will be helpful to have stored procedures instead of copying data between external tables or building views combining different files.

    10 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    completed  ·  2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →

  3. Allow Bulk insert from blob storage

    Due to the limitations currently in polybase its not an option for a lot of data sources. It would be great to be able to use bulk insert off blob storage like what is enabled in Azure SQL database as an option at least in the meantime.

    4 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →

  4. Expose Explain Plan XML Schema

    In order to build up tooling around the Explain Plan output having the XML Schema published and versioned is key. By having access to the schema, it will allow for integrator and ISV partners to know the shape of XML and properties contained in it.

    This will allow for easier integration to allow for processing etc. of the XML to help DW Users derive insight from the content of the Explain operation.

    3 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  AdminAzure Synapse Team (Admin, Microsoft Azure) responded

    We are moving to SHOWPLAN as the model for exposing query details. We have recently released full SHOWPLAN_XML support with graphical execution plans in SSMS 17.5. You can see the blog announcement here:
    https://azure.microsoft.com/en-us/blog/unlock-query-performance-with-sql-data-warehouse-using-graphical-execution-plans/

    You can download SSMS here:
    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

  • Don't see your idea?

Azure Synapse Analytics

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice