Forum Discussion
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
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.
Regards,
Srisakthi
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
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.
Regards,
Srisakthi