frithjo v on 21 Apr 2024 17:23:33
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.
- Comments (2)
RE: Dataflow Gen2 - Create tables in other data warehouse schemas
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.
RE: Dataflow Gen2 - Create tables in other data warehouse schemas
I concur but also want this available for writing to a different schema in Lakehouses.Scott