Azure Synapse Analytics
-
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.
185 votesThank you for all the feedback folks. Unfortunately this is taking longer than we’d like. We will reach back out when it is on the roadmap and can share when we have an update.
-
100 votes
Thank you for your feedback. Please help us understand your scenario by filling out the following short survey if you haven’t already:
https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR15GEFq-UVhGoldBoL_LA9RURUhGVVRWTUFQSlVOQlgwSjE5MEVBUDhXNi4u -
Enable CDM support for Azure Synapse Analytics SQL on-demand
The "Common Data Model" (CDM) format is becoming increasingly popular. Therefore it would be important that this connector not only exists in the ADF, but that it is also possible to read and write (via CETAS) in CDM directly from SQL on-demand.
READ:
SELECT * FROMOPENROWSET(
BULK STORAGE ACCOUNT,
FORMAT = CDM
) AS [r];WRITE:
CREATE EXTERNAL TABLE cdm.cdm_table
WITH (
LOCATION = path_to_folder,
DATA_SOURCE = external_data_source_name
FILE_FORMAT = CDM) AS SELECT * FROM source
44 votes -
'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.37 votesThank 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.
-
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.
22 votes -
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.
10 votes -
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 -
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 votesWe 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.
-
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 -
We require a shorter RPO for geo backups
In order to improve the RPO for our DR strategy, it is required to have a shorter RPO for geo backups where restore points can be geo-backed 2-3 times a day.
3 votes -
Enable synapse link for api cassandra in cosmosDB
Synapse link is possible only for api sql and api mongoDB in cosmosDB.
If we can have it for other api (cassandra and others) the synapse link available could allow us to have a better use of synapse analytics2 votes -
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 -
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 -
ADF pipeline call out boxes/annotations
It would be nice to allow users the capability to annotate the ADF pipeline activity with floating textbox and/or call out boxes. Similar to Visio call out boxes. Perhaps allow the user to hover over the pipeline activity to see the description and then pin the description so it's visible on the canvas as a call out box.
1 vote -
Elegant way to handle integration failures
Data Factory on failure activities are very limited. Perhaps, have an email activity or a write errors to file activity to help better trap copy activity errors.
1 vote -
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,
Sanjeev1 vote -
rowguicol
Bekanntes Feature aus dem SQL-Server, das bei Migrationen aktuell nicht mehr genutzt werden kann.
1 vote -
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 -
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 -
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
- Don't see your idea?