I have Source from SQL DB where data stored as JSON. Please see below image where record column has contains JSON.

[![enter image description here](https://i.stack.imgur.com/6Q5G8.png)](https://i.stack.imgur.com/6Q5G8.png)

The record column contains JSON Data like below. I am trying to flatten the JSON column so that each item inside the JSON suppose to be in tabular form. Is it possible to do this in Azure Data Factory?

```
{
   "resourceType":"Encounter",
   "id":"9i5W6tp-JTd-24252",
   "meta":{
      "versionId":"1591978948308",
      "lastUpdated":"2020-06-12T16:22:28.308Z"
   },
   "status":"finished",
   "class":{
      "system":"http://terminology.hl7.org/CodeSystem/v3-ActCode",
      "code":"AMB"
   },
   "type":[
      {
         "coding":[
            {
               "system":"http://snomed.info/sct",
               "code":"185345009",
               "display":"Encounter for symptom"
            }
         ],
         "text":"Encounter for symptom"
      }
   ],
   "subject":{
      "reference":"Patient/9i5W6tp-JTd-24249",
      "display":"Mrs. tonia30 back373"
   },
   "participant":[
      {
         "individual":{
            "reference":"Practitioner/9i5W6tp-JTd-24251",
            "display":"Dr. Stevie682"
         }
      }
   ],
   "period":{
      "start":"1962-05-27T08:26:51Z",
      "end":"1962-06-10T08:26:51Z"
   },
   "reasonCode":[
      {
         "coding":[
            {
               "system":"http://snomed.info/sct",
               "code":"232353008",
               "display":"Perennial allergic rhinitis with seasonal variation"
            }
         ]
      }
   ],
   "serviceProvider":{
      "reference":"Organization/9i5W6tp-JTd-24250",
      "display":"HOSPITAL"
   }
}

```