Forum Discussion
Dataflow Gen2 writing to Warehouse - how to change schema?
Hi, I'm writing a Gen2 dataflow to load some data into a Fabric Warehouse. When I create the "destination", the dialogs don't seem to have a place to enter what schema I want the tables created in - it defaults to dbo and I don't see a way to change that. Is it possible to write to schemas other than dbo - and if so how do I specify the proper schema?
Thanks!
Scott
Hi Scott,
You are correct, currently we only support dbo schema. It is in our current plan to add support for specifying a different schema by Q12024.
11 Replies
its a pain but i create them in dbo and then move them using a create as to the schema i want. then go back in and change dataflow and you can do existing table and pick the one with the correct schema and it will work.
Hi Scott,
You are correct, currently we only support dbo schema. It is in our current plan to add support for specifying a different schema by Q12024.
Thank you for confirming miquelladeboer !
Scott
Hi Scott_Powell ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries
Hi miquelladeboer , haven't seen any updates on this and didn't hear anything at the Fabric conference - any idea how far away supporting schemas in Warehouses is?
Thanks!
Scott
Hi Scott_Powell, we currently do not have an exact timeline to share, but it is in our plans to support in the future.
Hi Miquel,
Im doing an applied skills on Implement a datawarehouse: https://learn.microsoft.com/en-us/credentials/applied-skills/work-with-data-warehouses-using-microsoft-fabric
And there is a question on loading a table from Azure Storage Account into the staging schema.
My approach is using data flow gen 2 to ingest to dbo schema. Because I cant find the option to load into the staging schema. After that, I use SQL to create table as.... to copy the table from dbo schema to staging schema. Yet this is not efficient. Could you provide tips on this?
Anonymous is it safe to ALTER SCHEMA in Fabric? For transferring tables to a different schema than DBO after loading it to Warehouse
Here is an idea for this, please vote: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=452b78e0-0300-ef11-a73c-6045bdbe85bd
