topic Re: Dataflow Gen2 writing to Warehouse - how to change schema? in Dataflow

Dataflow Gen2 writing to Warehouse - how to change schema?

Scott_Powell — Tue, 17 Oct 2023 15:50:48 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

miquelladeboer — Tue, 17 Oct 2023 17:02:11 GMT

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.

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

Scott_Powell — Tue, 17 Oct 2023 17:35:48 GMT

Thank you for confirming miquelladeboer !

Scott

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

Anonymous — Wed, 18 Oct 2023 06:38:57 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

BiJoe — Fri, 23 Feb 2024 12:24:15 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

Scott_Powell — Mon, 08 Apr 2024 20:26:10 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

miquelladeboer — Mon, 08 Apr 2024 20:41:23 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

frithjof_v — Sun, 21 Apr 2024 17:24:56 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

khoirockfeather — Tue, 21 May 2024 09:09:20 GMT

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?

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

adana — Wed, 14 Aug 2024 17:36:55 GMT

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.

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

Anonymous — Wed, 28 Aug 2024 23:15:19 GMT

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

Re: Dataflow Gen2 writing to Warehouse - how to change schema?

OldDogNewTricks — Wed, 13 Nov 2024 20:29:51 GMT

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