How to add rows using ADF DataFlow

Abhijit Bhadra 91 Reputation points
2022-05-11T08:24:07.117+00:00

Hello All,

I have tables of Azure SQL DB which already transformed into JSON structure using ADF Dataflow.
Now rows need to be added, Alter Row will not work as my sink pointed to Blob storage container.
Below is the example of Data preview of sink post JSON transformation from a table from Azure SQL DB.

Column1 Column2 Column3
22C 189 True
23D 190 False

in this i need to add rows like

Column1 Column2 Column3
40N 223 True
41O 224 True

Please suggest any way to achieve this.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,082 questions
{count} vote