Forum Discussion
Solved
Gen2 df external table
[Edited by admin for unnecessary tagging without context]
A widely preferred pattern for data engineering with lakehouse for us has been creation of External Delta table. This is only possible for ...
At the moment, Dataflow Gen2 only loads data to tables. Do feel free to suggest new destinations (and formats) in the Fabric Ideas portal (https://aka.ms/FabricIdeas)
An alternative is to leverage the copy activity or a copy job. Especially as the bronze layer is typically used for the files in its raw state, so no transformation should be performed at that layer and instead a simple copy activity should be good enough. If a connector is missing from the copy job / copy activity, then would you mind letting us know what the source is? you can also post a new idea for such connector in the Ideas Portal.
I'm curious, what are the benefits of writing to files instead of just appending to a lakehouse bronze delta table?