Dataflow Gen2 writing to Warehouse - how to change schema?

[Scott_Powell]

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

[adana]

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.

[frithjof_v]

Here is an idea for this, please vote: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=452b78e0-0300-ef11-a73c-6045bdbe85bd

[BiJoe]

@Anonymous is it safe to ALTER SCHEMA in Fabric? For transferring tables to a different schema than DBO after loading it to Warehouse

[miquelladeboer · Accepted 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.

[Anonymous]

Hi,

I was facing this issue while moving the schema from development to production workspaces in fabric through deployment pipeline. I have many schemas in development workspace apart from dbo schema. But while deployment , only moving the dbo schema objects but not other schemas. Is there any other option we can achieve that ? since not possible to move manually individual objects to production

[khoirockfeather]

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?

[Scott_Powell]

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

[miquelladeboer]

Hi @Scott_Powell, we currently do not have an exact timeline to share, but it is in our plans to support in the future.

[OldDogNewTricks]

Any update on this functionality?  The idea link above does not work either.

[Scott_Powell]

Thank you for confirming @miquelladeboer !

Scott

[Anonymous]

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