Eventhouse data transformation

Hello svk666 

If you're ingetsing the live data in to event house, you no need to create EH shortcut and no neeed to go for Lakehouse for tarsformation. 

In evenhous eit self we have KQL, by using this you can transform the data, Once the data is transfomed you can build the dashboard from eventhouse itself. Pls read this thread https://community.fabric.microsoft.com/t5/Real-Time-Intelligence-Community/Eventhouse-and-its-best-practices/ba-p/5043560? it might helps you

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Hi svk666 ,

There are multiple ways in which you can do transformation either you can use event stream or directly ingesting to event house as per suparnababu8 . If there is any minimal transformation you can leverage predefined options in event stream, 

1. You can leverage SQL based transformation if you are more inclined with sql

Refer - https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-using-sql-code-editor

2.Ingest the data into Eventhouse and use notebook-based transformations directly within the Event Stream—there’s no need to create shortcuts or add separate logic.

Refer - https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/add-destination-spark-notebook

Regards,

Srisakthi