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. Support for Entity Framework

    Support for Entity Framework in Azure SQL Data Warehouse would allow for greater usability in general, but it would also allow for better support of other frameworks/protocols. Specifically, we have a need to serve our data through an OData feed, and Entity Framework's deferred execution would allow us to handle OData's Query Options in a much simpler way.

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

    We’ll send you updates on this idea

    16 comments  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  2. 100 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  3. 'Replication' solution from sql server to sql dataware house?

    Why not implement a Sql server 'Replication' solution from sql server (on premise / Azure) to sql dataware house (on Azure)?
    It would be useful if we have a processing DB in sql server and a accumulating datawarehouse in sql datawarehouse, with not too many structural changes.

    36 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 →

    Thank you for voting on this feature. Please describe your scenario in the thread below. We currently have many migration solutions from SQL Server to SQL Data Warehouse such as Azure Data Factory and Redgate through the Quick Load Azure portal experience (link below). If this is a continuous replication process, we’d love to understand your hybrid scenario so please comment below.

    https://azure.microsoft.com/blog/enhanced-loading-monitoring-and-troubleshooting-experience-for-azure-sql-data-warehouse/

  4. Allow CosmosDB linked data to be queried from SQL on-demand

    It would be really awesome to be able to query CosmosDB linked data using SQL on-demand! (too bad this isn't aready possible at this moment with synapse-link in preview).

    Please add this feature.

    10 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 →
  5. Make Power BI a "Trusted Microsoft Services" to the Azure Synapse

    Add Azure Functions as a trusted Microsoft service in Azure Synapse. Will help improve security around it and make it posible to Connect safely from Power BI and Synapse Studio.

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  6. Raise limit for nested case expressions from 10

    Various tools generate dynamic SQL and fail due to the limit "
    Case expressions may only be nested to level 10"

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  7. Geo Distributed Data Warehouse

    Please enable geographically distributed Data Warehouse.
    Different part of the data should be located in different clouds because of legal issues.

    EXAMPLE: we have sales data from US in one cloud, and from Europe in another. With one query, we would be able to consume total sales from Europe and US.

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →

    We currently support geo-backups to a secondary region. This item is under review for active geo-replication of a SQL Data Warehouse with cross database querying. Please vote for this feature here and comment with your scenario below. Thank you for your patience.

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

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

    We’ll send you updates on this idea

    started  ·  1 comment  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  9. Azure Active Directory (AAD) Connectivity to SQL Warehouse thru Excel

    We want to be flexible and if some teams needs to access sqlwarehouse thru Azure Active Directory instead of local DB Users it will be great and easy to provide access to data

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

    We’ll send you updates on this idea

    1 comment  ·  SQL/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow to share a self hosted IR from Data Factory to Synapse Studio

    As of now, it is not possible to reuse an existing Integration Runtime used in a Data Factory with Synapse Studio. This makes the migration and testing process much more complicated than it should be.

    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 →
  11. CETAS Export - Indicate completion usign a dummy status file

    When CETAS exports data into blob, there is no way for an external process to know if the entire file copy is complete or not. It would be good if SQL DW can create a dummy zero byte file named "status.complete" into the destination folder after all the data files are created. This will allow external process like ADF to watch for this file and trigger any downstream processing.

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  12. Integrate USQL into SQL Data Warehouse

    Seems like ADLA is going away in favor of Data Bricks. IMHO USQL was the magic that helped DBAs enter the "hadoop" universe. Think of your audience. Hopefully USQL will still be around and integrated in the SQL product family

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  13. Looks like there is no possibility of storage huge value in Synapse

    Dear Team,
    Please suggest or add ways to store CLOB (Oracle) data to Synapse. I can able to store upto 50k length but not more than that after adding index on individual column instead of ColumnStore.
    Regards,
    Sanjeev

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  14. rowguicol

    Bekanntes Feature aus dem SQL-Server, das bei Migrationen aktuell nicht mehr genutzt werden kann.

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  15. Full and simple integration between azure Datalake and azure DW with the notebooks running in any VM machine, Linux or Windows.

    Full and simple integration between azure Datalake and azure DW with the notebooks. Support for commom database connection drivers like pyodbc. And the most import, simple way to use Azure Active Directory log in to DW and Data Lake using Windows or Linux VM !

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  16. DMA for migrating Azure SQL Database to Azure SQL Data Warehouse

    Can you add Azure SQL Data Warehouse as one target and Azure SQL Database as one source in Microsoft Database Migration Assistant software?

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  17. Access to ADLA catalogs using Polybase

    It will be nice if we can access ADLA catalogs using Polybase , we can theoretically eliminate the process of ELT . Please share your thoughts .

    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/Integration  ·  Flag idea as inappropriate…  ·  Admin →
  18. I have source as a flat file having data in multiple lines in a string column, when I insert the same data into Azure SQL Datawarehouse data

    I have source as a flat file having data in multiple lines in a string column, when I insert the same data into Azure SQL Datawarehouse database, its removing the new line characters and data is appearing in a single line.

    I checked the data by copying into Notepad++ , its appearing in a single line.

    Is there any option in Azure SQL Datawarehouse database to fix this issue.

    Example: CREATE TABLE test ( ID VARCHAR(20) , TASK NVARCHAR(100) ) WITH ( CLUSTERED INDEX ( ID ) )

    Insert into table with multiple lines in TASK field

    insert into test…

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

Feedback and Knowledge Base