title: How to flatten JSON data in Azure Data Factory?
body: <p>I have Source from SQL DB where data stored as JSON. Please see below image where record column has contains JSON.</p>
  <p><a href="https://i.stack.imgur.com/6Q5G8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6Q5G8.png" alt="enter image description here" /></a></p>
  <p>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?</p>
  <pre><code>{
     &quot;resourceType&quot;:&quot;Encounter&quot;,
     &quot;id&quot;:&quot;9i5W6tp-JTd-24252&quot;,
     &quot;meta&quot;:{
        &quot;versionId&quot;:&quot;1591978948308&quot;,
        &quot;lastUpdated&quot;:&quot;2020-06-12T16:22:28.308Z&quot;
     },
     &quot;status&quot;:&quot;finished&quot;,
     &quot;class&quot;:{
        &quot;system&quot;:&quot;http://terminology.hl7.org/CodeSystem/v3-ActCode&quot;,
        &quot;code&quot;:&quot;AMB&quot;
     },
     &quot;type&quot;:[
        {
           &quot;coding&quot;:[
              {
                 &quot;system&quot;:&quot;http://snomed.info/sct&quot;,
                 &quot;code&quot;:&quot;185345009&quot;,
                 &quot;display&quot;:&quot;Encounter for symptom&quot;
              }
           ],
           &quot;text&quot;:&quot;Encounter for symptom&quot;
        }
     ],
     &quot;subject&quot;:{
        &quot;reference&quot;:&quot;Patient/9i5W6tp-JTd-24249&quot;,
        &quot;display&quot;:&quot;Mrs. tonia30 back373&quot;
     },
     &quot;participant&quot;:[
        {
           &quot;individual&quot;:{
              &quot;reference&quot;:&quot;Practitioner/9i5W6tp-JTd-24251&quot;,
              &quot;display&quot;:&quot;Dr. Stevie682&quot;
           }
        }
     ],
     &quot;period&quot;:{
        &quot;start&quot;:&quot;1962-05-27T08:26:51Z&quot;,
        &quot;end&quot;:&quot;1962-06-10T08:26:51Z&quot;
     },
     &quot;reasonCode&quot;:[
        {
           &quot;coding&quot;:[
              {
                 &quot;system&quot;:&quot;http://snomed.info/sct&quot;,
                 &quot;code&quot;:&quot;232353008&quot;,
                 &quot;display&quot;:&quot;Perennial allergic rhinitis with seasonal variation&quot;
              }
           ]
        }
     ],
     &quot;serviceProvider&quot;:{
        &quot;reference&quot;:&quot;Organization/9i5W6tp-JTd-24250&quot;,
        &quot;display&quot;:&quot;HOSPITAL&quot;
     }
  }
  </code></pre>