How to read data from the snowflake table and parse complex JSON data fields into proper columns and insert them into the snowflake table?

Matillion ETL
1

Want to extract first_name, last_name, gender, birthdate from

[

  {

   "entry":[

     {

      "resource":{

        "address":[

         {

           "city":"ype",

           "line":[

            "491 Lamkani"

           ],

           "postalCode":"411018",

           "state":"XY"

         }

        ],

        "birthDate":"1992-12-31",

        "gender":"male",

        "id":"8e1c3d2e-7c59-4e5a-a053-8ec602b2ec6b",

        "meta":{

         "lastUpdated":"2023-03-31T13:08:05.847077+00:00"

        },

        "name":[

         {

           "family": "giva",

           "given":[

            "jiva"

           ]

         }

        ],

        "resourceType": "xyz",

        "telecom":[

         {

           "system": "phone",

           "value": "67845678"

         }

        ]

      }

     }

]}]

2

Try the "Extract nested data" component (https://documentation.matillion.com/docs/2978311). It is really hepful to convert JSON to a relational structure.

3

Thanks!