cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhorrall
Frequent Visitor

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

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

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

dhorrall_1-1685046922309.png

 

I ended up with:

dhorrall_2-1685047007059.png

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.

 

 

3 REPLIES 3
Pfisterbi
Frequent Visitor

Run into the same issue.

We need a possibility to choose a schema.

SidJay
Microsoft
Microsoft

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

miguel
Community Admin
Community Admin

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.

Helpful resources

Announcements
Welcome to the Data Factory (preview) Community

Join Today

Learn more about the Data Factory (preview) Community and how you can participate.

Get Help with Data Factory in the General Discussion Forum

General Discussion Forum

Ask your questions about Data Factory here!

Webinars and Video Gallery

Webinars and Video Gallery

Learn more about Data Factory through webinars and short videos.

Carousel_Build_v2

Check out the latest on analytics in Microsoft Fabric!

Microsoft Fabric brings everything you need into one analytics solution.

Top Solution Authors