Forum Discussion
Fabric Dataflow Gen2 Destination Schema
Hi Chaps, I'm not sure if this has been answered, but I did some digging and couldn't find anything. I have Gen2 Dataflow in Fabric, which picks a warehouse as the destination. I've created 3 sc...
Agreed. It would be very beneficial to configure a Dataflow Gen2 to have its Warehouse destination be a NEW table in something other than the dbo schema.
If you try to use two-part reference in the (new) Table Name option while configuring the destination, yoiu get an error that the name can contain only letters and numbers, etc.
Side note: two-part object reference is STANDARD OPERATING PROCEDURES and also considered a BEST PRACTICE. I ALWAYS reference tables with two-part names, even when they are in the dbo schema.
NOT having this is a huge pain!.