Forum Discussion

souvik666's avatar
souvik666
New Member
3 months ago
Solved

Eventstream Doubt

Suppose I use an EvenStream and I have 2 data sources with 2 different types of schemas, and I want to dump the data to the Evenhouse DB in two different tables. How do I segregate the 2 types of dat...
  • arabalca's avatar
    3 months ago

    Hi souvik666 ,

     

    Your diagram already shows the correct approach! The pattern you've implemented is exactly what Microsoft recommends for this scenario. What is the questions?

     

    What you've done right:

    • Two separate sources (YellowTaxi and Kafka_Src) feeding into a single Eventstream (EV_prod)
    • A Filter node per branch to separate the data by origin
    • Two independent Eventhouse destinations (EH_Kafka and EH_Taxi) pointing to different tables in the same KQL database
    • This is the standard way to route data from multiple sources with different schemas into separate Eventhouse tables — no code required, just the visual editor.

    Official documentation:

    Overview & multiple destinations: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/overview

     

    If my comments helped solve your question, it would be great if you could like the two comments and mark it as the accepted solution. It helps others with the same issue and also motivates me to keep contributing.

     

    Thanks a lot, I really appreciate it.