Azure Synapse: Truncate and Load feeds

Vivek Devalkar 122 Reputation points
2020-12-22T23:25:16.857+00:00

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.
9,531 questions
0 comments No comments
{count} votes

Accepted answer
  1. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee
    2020-12-23T00:45:27.07+00:00

    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.

    50518-image.png

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. IJH 1 Reputation point
    2022-03-04T08:54:21.75+00:00

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