Forum Discussion
dhorrall
Advocate I
Advocate IDataflow (Gen2): Fabric Warehouse Destination...this was unexpected!
Scenario
I wanted to create a Dataflow that changed some data and load the result to a Fabric Warehouse table.
At first, I thought it would not work directly. I only see Azure SQL Database, ...
You can think of the "Azure Synapse Analytics (SQL DW)" entry as "Fabric Warehouse". We will be fixing the UI to address the incorrect naming.
Hi, we are currently rolling out the Fabric warehouse connector for output destinations in dataflow gen 2. With this new connector you can browse you Fabric workspaces and select your warehouse from the navigator experience in the same way as you currently can with the Fabric Lakehouse connector. This capability will come to your region very soon!
In the meantime, you can use the Azure Synapse Analytics (SQL DW) connector to load your data to the Fabric warehouse.
vitaly
Advocate II
Advocate IIA few related questions, to clarify the level of support for Fabric Warehouse as the destination of Fabric Dataflows Gen2:
- According to the documentation at https://learn.microsoft.com/en-us/fabric/data-factory/dataflows-gen2-overview, Fabric Lakehouses as explicitly supported, while Fabric Warehouses are not. Is this documentation aspect out of date? If so, can it please be updated?
- We are seeing "New Dataflow Gen2" as an option under "Get Data" in a Lakehouse for all users. We are only seeing it as an option for Warehouse for some users, while others do not see it. What's driving selective availability of this option? Is a feature update currently rolling out in phases?
- What are the consequences of using the "Azure Synapse Analytics (SQL DW)" connector to write to a Fabric Warehouse? Given that the Synapse Dedicated SQL pool engine (i.e. "SQL DW") is different from the Fabric Warehouse engine, does the same connector (under whichever label) now support both engines?
Thank you!