Azure Synapse: Truncate and Load feeds

Vivek D 81 Reputation points

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?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,671 questions
No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. IJH 1 Reputation point

    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..