Forum Discussion

Debasish_p's avatar
Debasish_p
Frequent Visitor
2 years ago
Solved

Flatten nested JSON in KQL DB

Hi All, Is there a way to flatten and ingest nested JSON into KQL DB using Real time analytics. Consider it as a one time load from Onelake.
Eventstream
Real-time Analytics
  • Debasish_p's avatar
    Debasish_p
    2 years ago

    Hi,

    Hi All, the issue has been resolved. Below are the steps that I have done to resolve the issue.

    1. Create 2 tables. One AS-IS(Staging) table and the otheris an target table

    2. Create a KQL function and

    3. adding it as an update policy in the target table.

     

    Thanks

Debasish_p's avatar
Debasish_p
Frequent Visitor
2 years ago

Thanks HimanshuS-msft , the above solution involves ADF. I was looking at flattening while directly ingesting in KQL DB.