Dataflow Gen2 - Create tables in other data warehouse schemas

[fbcideas_migusr]

When using Dataflow Gen 2 to create new tables in Data Warehouse, I would like the ability to select which data warehouse schema the table will be created in.

Today, it is only possible to create new tables in the dbo schema from Dataflow Gen 2.

[Scott_Powell1]

I concur but also want this available for writing to a different schema in Lakehouses.

Scott

[jordan_lazarus_]

This is definitely needed. We have the ability to select a particular datawarehouse as a destination of a dataflow but even if the schema name is specified as part of the new table name like schema.table, the table is only created in the dbo schema with name "schema.table" - which is not the expected. As a work around you always have to create a table manually, and then specify the destination as an existing table - which is a lot more work and not fulfilling the requirement of selecting the proper destination.

[Fisherman]

Please, what's the update on this idea ?

[stephenburgess]

I'd like to upvote this as well. @jordan_lazarus_ Another workaround is to go into the warehouse after loading the table into the `dbo` schema and doing `SELECT * INTO [new_schema].[table] FROM [dbo].[table]` followed by `DROP TABLE [dbo].[table]` (be careful to drop the correct table). Wanted to share in case that is helpful at all. As for a workaround that doesn't work, don't use "Clone Table" for this. Clone table requires the original table to exist, so you can't use a clone of a dropped original table.

[sanjeewat]

Any update on this please?

[miguel]

This is currently available. Here's the documentation article that talks more about how you can enable the schema view when connecting to a Warehouse:

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn

[rafalencar1997]

Just to complement the solution: here is the specific link from documentation that allows choosing Lakehouse and Warehouse schemas besides dbo https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-data-destinations-and-managed-se...