Is it possible to create a materialized view in a Fabric warehouse? If not, what alternatives are available besides creating aggregated physical tables?

Hey folks, I am wondering if anyone has implemented a solution where we keep log of pipeline run in warehouse table. (nested pipelines) So far the things I tried: - Invoke pIpeline (preview) activity does return some properties useful to get the details of any child pipeline invoked. - Invoke Pipeline (Legacy) activity don't have any such property so it's sort of difficult to get the child run details. - Tested job scheduler API to get job instance, again this only supports the Pipeline Run Id's when pipeline is invoked manually (using UI) and does not accept the one's triggered using Invoke Pipeline activity (error 404) :( -

Hi folks, I have cleared DP600 today. Thanks to the community and @Will Needham your videos and notes definitely showed the path to stay on right track throughout the learning process. Major areas I saw, External tools (Tabular Editor & DAX studio) Couple questions on Git integration Then regular DAX, SQL, PySpark code Data pipeline and orchestration.

Hey everyone, I'm looking for the simplest yet most effective tool for creating architectural block diagrams with Fabric and Azure elements. I usually use Draw.io, but it has limitations when it comes to Fabric icons. Any recommendations?

I'm exploring using a warehouse instead of a lakehouse because it offers schema-level tracking with the deployment pipeline. In my architecture, I'm loading data from the source into the warehouse (wh_level1) using DF Gen2. Now, I need to access the same data from warehouse (wh_level1) in another warehouse (wh_level2) from different workspace without creating additional copies, similar to how shortcuts work in a lakehouse. I'm curious if there's a way to query data across workspaces. The Microsoft documentation mentions it, but it doesn't provide a detailed explanation of how to do this. Refer: https://learn.microsoft.com/en-us/fabric/data-warehouse/tutorial-sql-cross-warehouse-query-editor