Share via

Hey. Can we have streaming data from lake house to ware house in fabric ?

Manideep Reddy 0 Reputation points
2025-10-23T06:20:57.86+00:00

I am using database mirroring to bring data from SQL Server into Fabric. Then, using a Notebook, I bring that data into the Lakehouse. Up to this point, the data is streaming in real-time.

Now, I want to bring streaming data from the Lakehouse to a Warehouse. I initially thought of using views, but I want to know if there is another option to enable streaming data from the Lakehouse to the Warehouse, instead of relying on views.

Azure Data Lake Analytics

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Smaran Thoomu 32,530 Reputation points Microsoft External Staff Moderator
    2025-10-23T10:45:43.6333333+00:00

    Hi Manideep Reddy

    At present, Fabric doesn’t support direct streaming from a Lakehouse to a Warehouse. The two stores are separate, so there’s no built-in real-time sync.

    You can:

    • Use views or shortcuts in the Warehouse to reference Lakehouse tables for near real-time access, or
    • Use a Notebook or Dataflow Gen2 to copy data on a scheduled basis if you need the data physically in the Warehouse.

    For now, the view-based approach is the best option until native streaming between Lakehouse and Warehouse becomes available in Fabric.

    Hope this helps!

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.