Getting json payload from Azure Event Grid / Event Hubs and just save it to the Lakehouse

[foks]

Hello,

I have Azure Event Grid Namespace topic and I want to save event as it is, in json format to the Lakehouse/Files. But I can't do it. The json is automatically flattened and saved as delta table. How I can change this?

[svelde]

Hello @foks ,

Welcome to this community forum.

Have you considered forwarding incoming MQTT messages in the Eventhouse?

Check out this blogpost for details.

I ask this because a timeseries is in most cases a better fit for data arriving as event, measurements, immutable telemetry.

the KQL query language is perfect for working with time-based data.

If you still need a (JSON) file for other tooling, you can use a Lakehouse shortcut so the data appears as a table.

If this answer helps you, a thumbs-up or marking it as accepted answer is appreaciated.

[Pragati11]

Hi @foks 

Once your data is loaded, a delta folder is created. If you navigate into that, you should be able to see json file as well.

I am assuming you have a streaming data from Azure Event Hub loaded to KQL database in MS Fabric.

Let me know if my underastnd is correct, otherwise share more details like screenshots here.