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

Hello 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 .
If creted support ticket, please provide the ticket number as it would help us to track for more information.

Debasish_p's avatar
Debasish_p
Frequent Visitor
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 ,

    Glad to know your query got resolved. Please continue using Fabric Community for your further queries.