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. [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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    105 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    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?

Feedback and Knowledge Base