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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Debasish_p ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .