Medallion Lakehouse

A cited, runnable solution pattern for an investment management analytics platform on Microsoft Fabric: three ingestion paths (Data Factory file Copy, Mirroring of an operational portfolio/transactions database, and Data Factory API pulls) feeding one lakehouse holding both bronze and silver, a dbt-built gold warehouse orchestrated via Airflow in Data Factory, Direct Lake/Power BI serving, and telemetry split between Eventhouse and a Fabric SQL database control plane. Includes DDL, pipeline parameter sketches, a PySpark conform notebook, and a full dbt project layout.

A cited reference architecture for the medallion (bronze/silver/gold) data pattern on a Fabric lakehouse: one physical Delta-Parquet copy in OneLake, engine-per-workload ingestion, Spark transformation with V-Order and Optimized Write, and serving through the SQL analytics endpoint or Direct Lake. Grounded only in verified KB claims; inferences are labelled.

A cited reference architecture for serving interactive Power BI reports directly from a Fabric lakehouse over OneLake using Direct Lake, with capacity sizing guidance and grounded internals. Grounded only in verified claims; inferences are labelled.

A cited solution-pattern article for bronze, silver, and gold curation on a Fabric lakehouse over OneLake, with Spark transformation, Delta table layout, SQL endpoint serving, and Direct Lake consumption.

A working prototype walkthrough of a medallion data platform for investment, risk-analytics, and performance datasets on Microsoft Fabric: metadata-driven ingestion via Data Factory, Files, and Mirroring; a single bronze+silver lakehouse; a dbt-built gold Warehouse orchestrated by Airflow; and Eventhouse telemetry.