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...
There is a shortcut I managed to figure out, and it does the job. If you create the table under the new schema, you can change the destination and select the existing table under the correct schema.
Ideally this option should be available under the wizard but I understand the app is still in beta mode.
Yes, this works, but if your table is of any decent size, manually creating it is a pain, so SSMS comes into play here as it allows the "Script table as >> Create..." option. Fabric does NOT have this capability, unfortunately.
