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..
Hello @daJahrenHerud-4996,
Since this thread is too old, I would recommend creating a new thread on the same forum with as much details about your issue as possible. That would make sure that your issue has better visibility in the community.