Forum Discussion
Different schema into different destination
Hello Everyone,
I have a scenario where I'm getting events with two diffferent schema flowing into event stream and i want to push those events into two different destination tables or two different destination(event house and lakehouse). Is there any best way to achieve this?
Do we need to create two different event stream?
What should be the best practise to handle this situation?
Regards,
Srisakthi
Hi Srisakthi
Yes, that’s correct.
The link I shared previously refers exactly to this:
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-with-multiple-schemas#view-and-update-the-inferred-schemasTake a look and try it based on your case. Let me know if this helps resolve the issue.
If this helps solve your problem, I’d appreciate it if you could mark it as the accepted solution and give it a like
Thanks!
6 Replies
- arabalcaSuper User
Hi Srisakthi
You don't need two Eventstreams. With a single one you can handle this by enabling Multiple Schema Inferencing (preview): each branch of the flow uses its own inferred schema and routes to its corresponding destination (Eventhouse or Lakehouse).
Here's the official step-by-step:
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-with-multiple-schemas
Give it a try and if it works for you, mark it as solution and give it a like! 😊- arabalcaSuper User
Hi Srisakthi ,
If you review the documentation, you’ll see that you have the option to work with different data sources or with the same source, depending on your scenario:
Take a look and try it based on your case. Let me know if this helps resolve the issue.
If this helps solve your problem, I’d appreciate it if you could mark it as the accepted solution and give it a like 👍
Thanks!
- arabalcaSuper User
Hi Srisakthi
Yes, that’s correct.
The link I shared previously refers exactly to this:
https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/process-events-with-multiple-schemas#view-and-update-the-inferred-schemasTake a look and try it based on your case. Let me know if this helps resolve the issue.
If this helps solve your problem, I’d appreciate it if you could mark it as the accepted solution and give it a like 👍
Thanks!