store json object to azure table storage entity using azure data factory pipeline

0
votes

I've created one azure data factory pipeline. By which, I need to store my JSON file content as string from my blob storage JSON file to azure table storage entity.

I tried with copy activity where the source is my blob storage JSON file and destination is my azure table storage's table where I need to store that.

Finally, I need the content of my JSON file to an entity of table storage as below. enter image description here

1
jsonazure-table-storageazure-data-factorydataflow

1 Answers

1
votes

You can copy data from a blob storage JSON file to Azure table by having the source and the sink in the copy activity.

In the mapping tab of the copy activity, you can define the mapping between the attributes of the JSON file and the table as shown below : enter image description here