Forum Discussion
DataFlow Choose destination settings "Use automatic settings" disabled
Please check the documentation available for this:
answering some of the questions that I've seen on this thread:
- Automatic settings are only supported for Lakehouse and Azure SQL database
- Automatic settings can only be applied to new tables
- Dynamic table schema options on publish can only be selected when using the "Replace" update method
As mentioned in some previous replies, there are some experiences that perhaps don't exist today in Dataflow Gen2. For any of those please feel free to post an idea in the Fabric ideas portal (aka.ms/FabricIdeas)
if you can't use the "automatic settings" when trying to create a new table to a Lakehouse or an Azure SQL DB, please feel free to open a support ticket and reply to this message with the case number. I'll elevate it and have the engineering team take a closer look as to what might be causing such bug.
Please do refer to the documentation available that covers the current supported scenarios and limitations.
First, I created the schema "testSchema" and the table "table1" in my Data Warehouse:
In my Dataflow Gen2, I can find the table:
frithjof,
Presicely the point! The table needs to be first created in the schema, and this is not the scenario that I am describing or described... There should be a way to assigned the target schema not forcing the creation of the table before hand.
My vote is to have the as described above and not force the pre-creation of the tables to be targets.
I see, now I understand,
Okay I have created an idea for this, please vote:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=452b78e0-0300-ef11-a73c-6045bdbe85bd
Here is also another thread about the same topic: