topic Re: Dataflow (Gen2): Specifying target table schema if is a new table in Dataflow

Dataflow (Gen2): Specifying target table schema if is a new table

dhorrall — Fri, 09 Jun 2023 03:01:21 GMT

I tried to create a new table in a target Warehouse.

When I tried to create a new table with tst.theTable,

I ended up with:

It seems to use the schema from the 'source' table I was extracting from (which was 'coupa')

I see no place to specifiy the target schema explicitly other than what I tried with 'dot' notation in the table name field.

Putting aside the fact that I am writing to a Fabric Warehouse, even though I chose Azure SQL Server as the target. This seems like a bug.

Re: Dataflow (Gen2): Specifying target table schema if is a new table

miguel — Thu, 25 May 2023 23:12:07 GMT

Thank you for the feedback! I went ahead and forwarded this information to the appropriate internal team so they can take a look at this thread.

Re: Dataflow (Gen2): Specifying target table schema if is a new table

SidJay — Fri, 26 May 2023 01:36:37 GMT

There isn't currently a way to customize the schema. We are tracking this as a feature gap.

Re: Dataflow (Gen2): Specifying target table schema if is a new table

Pfisterbi — Mon, 29 May 2023 14:44:04 GMT

Run into the same issue.

We need a possibility to choose a schema.

Re: Dataflow (Gen2): Specifying target table schema if is a new table

webchris — Wed, 15 Nov 2023 11:23:39 GMT

Yeah, I think so, too...

Re: Dataflow (Gen2): Specifying target table schema if is a new table

webchris — Wed, 15 Nov 2023 11:24:39 GMT

Hi Miguel miguel

Any news on this?

Re: Dataflow (Gen2): Specifying target table schema if is a new table

webchris — Thu, 23 Nov 2023 09:38:57 GMT

What is the status of this, is there a chance to track this?

Re: Dataflow (Gen2): Specifying target table schema if is a new table

miquelladeboer — Wed, 13 Dec 2023 22:34:37 GMT

This is still on our feature list, but we do not have a current timeline yet. Any improvements to outputdestinations and their timelines can be tracked here: What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Re: Dataflow (Gen2): Specifying target table schema if is a new table

danjo914 — Wed, 24 Apr 2024 00:35:23 GMT

A crude workaround involves initially creating the table within the desired schema, then selecting it as an existing table in your dataflow. Afterwards, you can utilize the dataflow to generate the table under the dbo schema, perform a drop and create action to move it to the new schema, and redirect the dataflow. Note that default data types like bigints and varchar (8000) will be applied initially, but they can be corrected using the drop & create query.

Re: Dataflow (Gen2): Specifying target table schema if is a new table

webchris — Wed, 24 Apr 2024 06:17:15 GMT

Okay great, this will definately help. Many thanks for the idea!