Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Dataflow Gen2 - Create tables in other data warehouse schemas

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.

Status: Planned
Comments
Scott_Powell1
New Member

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

Scott

jordan_lazarus_
New Member

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.

fbcideas_migusr
New Member
Status changed to: New
 
miguel
Community Admin
Status changed to: Planned
 
Fisherman
New Member
Please, what's the update on this idea ?