JSON Column Extraction

[sumitk]

Hi All,

While I am extracting the data from the table available in DB there is a JSON column in table, If I excluded that JSON column then my complete table extraction done within 2 Minutes but when I include that JSON column it is taken more than 4 hours to extract complete table.

Please suggest me a solution to perform faster extraction including JSON column.

Thanks in advanced.

[ajaykakkar93]

Hi,
You can use JsonGet() method to get specific data from json
example:
JsonGet(og,'/proposerDetail/member/relationship') as [_proposerDetail_member_relationship],