Forum Discussion
Solved
Dataflow (Gen2): Specifying target table schema if is a new table
I tried to create a new table in a target Warehouse.
When I tried to create a new table with tst.theTable,
I ended up with:
It seems to use the schema from the 'source' t...
This is still on our feature list, but we do not have a current timeline yet. Any improvements to outputdestinations and their timelines can be tracked here: What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
A crude workaround involves initially creating the table within the desired schema, then selecting it as an existing table in your dataflow. Afterwards, you can utilize the dataflow to generate the table under the dbo schema, perform a drop and create action to move it to the new schema, and redirect the dataflow. Note that default data types like bigints and varchar (8000) will be applied initially, but they can be corrected using the drop & create query.
Okay great, this will definately help. Many thanks for the idea!