Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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.
Here is an idea for this, please vote: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=452b78e0-0300-ef11-a73c-6045bdbe85bd
@v-gchenna-msft is it safe to ALTER SCHEMA in Fabric? For transferring tables to a different schema than DBO after loading it to Warehouse
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.
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-microso...
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?
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 @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