Have a look at the Sink Settings in Data Flows, similar to SSIS data flows. You'll see options there for insert, update, delete, truncate, etc.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Just starting to explore Azure Synapse as a replacement/upgrade for our on-premise SQL Server/SSIS/SSAS based solution.
Majority of our feeds follow a truncate and load approach. Was hoping in Synapse (ADF) it would be something as simple as enabling a checkbox to truncate and load data into a table but I've been unable to find even a round about way to achieve that.
What's the best practice to do a truncate and load in Synapse/ADF?
Have a look at the Sink Settings in Data Flows, similar to SSIS data flows. You'll see options there for insert, update, delete, truncate, etc.
I have the same settings but when I run this on an allready populated table it only truncates the data, but it does not insert anything..