Forum Discussion
Regarding Adding reference data to my stream in Microsoft fabric event stream.
Makes sense. In this case, the pattern is established. Eventstream loads the initial stream into Eventhouse, where the stream is contextualized with the reference data and written to a new table. Then create a new eventstream that uses an Azure Data Explorer source (with the Eventhouse uri information). Even though the source says ADX Eventhouse is the same engine.
Then add a custom endpoint destination where your customer can subscribe. THe other thing you could consider is rather streaming back into the eventstream simply make the data available in eventhouse via the rest api
Hi PeterP1 , I even tried this approach of loading my static data into fabric sql database and adding as refernce data. but i was not able to see the option for connecting to my fabric sql database..i can see only CDC type connections.
Thank you,
Venu M
Community SupportHi VENUMADDIPATI52 ,
Thanks for the update.
At present, Eventstream doesn’t yet provide a way to directly add a Fabric SQL Database as data source/ reference data, which is why you don’t see it listed in the dropdown.
The only options currently available are the ones visible in the data source list: Microsoft Fabric event streams overview - Microsoft Fabric | Microsoft Learn
Similar discussion: Solved: Re: How to Use a Fabric SQL Database as a Source i... - Microsoft Fabric Community
Hope this helps. Please reach out for further assistance.
Thank you.