# anujshukla2610/fabric_poc architecture

> Architecture diagram of the GitHub repository anujshukla2610/fabric_poc, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-19). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/anujshukla2610/fabric_poc
- Repository: https://github.com/anujshukla2610/fabric_poc

## Overview

This repository is a Microsoft Fabric proof of concept for lakehouse and warehouse data work. The visible workflow uses notebooks to create customer, product, and sales tables in a configured lakehouse, with separate notebooks demonstrating reads and table recovery. The tree also contains a dataflow, pipelines, and warehouse projects, but their contents and wiring were not sampled; the README provides no further workflow documentation, so those components are shown without inferred connections.

Main entry points: [`DRPOCLakehouse.Lakehouse/lakehouse.metadata.json`](https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCLakehouse.Lakehouse/lakehouse.metadata.json) (DRPOC lakehouse), [`DR_POC_Notebook.Notebook/notebook-content.py`](https://github.com/anujshukla2610/fabric_poc/blob/main/DR_POC_Notebook.Notebook/notebook-content.py) (Build dimensions and sales), [`Notebook 1.Notebook/notebook-content.py`](https://github.com/anujshukla2610/fabric_poc/blob/main/Notebook%201.Notebook/notebook-content.py) (Build customers), [`Notebook 2.Notebook/notebook-content.py`](https://github.com/anujshukla2610/fabric_poc/blob/main/Notebook%202.Notebook/notebook-content.py) (Table recovery)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_lakehouse["Lakehouse notebooks"]
  node_dr_notebook["Build dimensions and sales"]
  node_lh_notebook["Build customers"]
  node_recovery_notebook["Table recovery"]
  node_query_notebook["Read lakehouse tables"]
  node_dr_lakehouse[("DRPOC lakehouse")]
  node_lh_lakehouse[("lh lakehouse")]
end

subgraph group_orchestration["Data orchestration"]
  node_dataflow["Dataflow<br/>[mashup.pq]"]
  node_dr_pipeline["DR POC pipeline"]
  node_pipeline["Pipeline 1"]
end

subgraph group_warehouses["Warehouse schemas"]
  node_dr_warehouse[("DR POC warehouse")]
  node_customer_table[("Customer dimension<br/>[dim_customer.sql]")]
  node_product_table[("Product dimension<br/>[dim_product.sql]")]
  node_sales_table[("Sales fact<br/>[fact_sales.sql]")]
  node_test_warehouse[("Recovery test warehouse<br/>[WS_Test.sqlproj]")]
  node_recovery_table[("Recovery test table")]
end

node_operator(("Fabric user"))

node_operator -->|"runs"| node_dr_notebook
node_operator -->|"runs"| node_lh_notebook
node_operator -->|"runs"| node_recovery_notebook
node_operator -->|"runs"| node_query_notebook
node_dr_notebook -->|"writes tables"| node_dr_lakehouse
node_lh_notebook -->|"writes customer"| node_lh_lakehouse
node_recovery_notebook -->|"restores table"| node_dr_lakehouse
node_query_notebook -->|"queries tables"| node_dr_lakehouse

click node_dr_notebook "https://github.com/anujshukla2610/fabric_poc/blob/main/DR_POC_Notebook.Notebook/notebook-content.py"
click node_lh_notebook "https://github.com/anujshukla2610/fabric_poc/blob/main/Notebook%201.Notebook/notebook-content.py"
click node_recovery_notebook "https://github.com/anujshukla2610/fabric_poc/blob/main/Notebook%202.Notebook/notebook-content.py"
click node_query_notebook "https://github.com/anujshukla2610/fabric_poc/blob/main/DR_Test_Notebook.Notebook/notebook-content.py"
click node_dr_lakehouse "https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCLakehouse.Lakehouse/lakehouse.metadata.json"
click node_lh_lakehouse "https://github.com/anujshukla2610/fabric_poc/blob/main/lh.Lakehouse/lakehouse.metadata.json"
click node_dataflow "https://github.com/anujshukla2610/fabric_poc/blob/main/Dataflow%201.Dataflow/mashup.pq"
click node_dr_pipeline "https://github.com/anujshukla2610/fabric_poc/blob/main/DR_POC_Pipeline.DataPipeline/pipeline-content.json"
click node_pipeline "https://github.com/anujshukla2610/fabric_poc/blob/main/Pipeline_1.DataPipeline/pipeline-content.json"
click node_dr_warehouse "https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/DRPOCWarehouse.sqlproj"
click node_customer_table "https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/dbo/Tables/dim_customer.sql"
click node_product_table "https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/dbo/Tables/dim_product.sql"
click node_sales_table "https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/dbo/Tables/fact_sales.sql"
click node_test_warehouse "https://github.com/anujshukla2610/fabric_poc/blob/main/WS_Test.Warehouse/WS_Test.sqlproj"
click node_recovery_table "https://github.com/anujshukla2610/fabric_poc/blob/main/WS_Test.Warehouse/dbo/Tables/dr_recovery_test.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dr_notebook,node_lh_notebook,node_recovery_notebook,node_query_notebook,node_dr_lakehouse,node_lh_lakehouse,node_operator toneBlue
class node_dataflow,node_dr_pipeline,node_pipeline toneAmber
class node_dr_warehouse,node_customer_table,node_product_table,node_sales_table,node_test_warehouse,node_recovery_table toneMint
```

## Components

### Lakehouse notebooks

- [Build dimensions and sales](https://github.com/anujshukla2610/fabric_poc/blob/main/DR_POC_Notebook.Notebook/notebook-content.py): `DR_POC_Notebook.Notebook/notebook-content.py`
- [Build customers](https://github.com/anujshukla2610/fabric_poc/blob/main/Notebook%201.Notebook/notebook-content.py): `Notebook 1.Notebook/notebook-content.py`
- [Table recovery](https://github.com/anujshukla2610/fabric_poc/blob/main/Notebook%202.Notebook/notebook-content.py): `Notebook 2.Notebook/notebook-content.py`
- [Read lakehouse tables](https://github.com/anujshukla2610/fabric_poc/blob/main/DR_Test_Notebook.Notebook/notebook-content.py): `DR_Test_Notebook.Notebook/notebook-content.py`
- [DRPOC lakehouse](https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCLakehouse.Lakehouse/lakehouse.metadata.json): `DRPOCLakehouse.Lakehouse/lakehouse.metadata.json`
- [lh lakehouse](https://github.com/anujshukla2610/fabric_poc/blob/main/lh.Lakehouse/lakehouse.metadata.json): `lh.Lakehouse/lakehouse.metadata.json`

### Data orchestration

- [Dataflow](https://github.com/anujshukla2610/fabric_poc/blob/main/Dataflow%201.Dataflow/mashup.pq): `Dataflow 1.Dataflow/mashup.pq`
- [DR POC pipeline](https://github.com/anujshukla2610/fabric_poc/blob/main/DR_POC_Pipeline.DataPipeline/pipeline-content.json): `DR_POC_Pipeline.DataPipeline/pipeline-content.json`
- [Pipeline 1](https://github.com/anujshukla2610/fabric_poc/blob/main/Pipeline_1.DataPipeline/pipeline-content.json): `Pipeline_1.DataPipeline/pipeline-content.json`

### Warehouse schemas

- [DR POC warehouse](https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/DRPOCWarehouse.sqlproj): `DRPOCWarehouse.Warehouse/DRPOCWarehouse.sqlproj`
- [Customer dimension](https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/dbo/Tables/dim_customer.sql): `DRPOCWarehouse.Warehouse/dbo/Tables/dim_customer.sql`
- [Product dimension](https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/dbo/Tables/dim_product.sql): `DRPOCWarehouse.Warehouse/dbo/Tables/dim_product.sql`
- [Sales fact](https://github.com/anujshukla2610/fabric_poc/blob/main/DRPOCWarehouse.Warehouse/dbo/Tables/fact_sales.sql): `DRPOCWarehouse.Warehouse/dbo/Tables/fact_sales.sql`
- [Recovery test warehouse](https://github.com/anujshukla2610/fabric_poc/blob/main/WS_Test.Warehouse/WS_Test.sqlproj): `WS_Test.Warehouse/WS_Test.sqlproj`
- [Recovery test table](https://github.com/anujshukla2610/fabric_poc/blob/main/WS_Test.Warehouse/dbo/Tables/dr_recovery_test.sql): `WS_Test.Warehouse/dbo/Tables/dr_recovery_test.sql`

### Other components

- **Fabric user**

## Connections

- Fabric user → Build dimensions and sales: runs
- Fabric user → Build customers: runs
- Fabric user → Table recovery: runs
- Fabric user → Read lakehouse tables: runs
- Build dimensions and sales → DRPOC lakehouse: writes tables (evidence: `DR_POC_Notebook.Notebook/notebook-content.py`)
- Build customers → lh lakehouse: writes customer (evidence: `Notebook 1.Notebook/notebook-content.py`)
- Table recovery → DRPOC lakehouse: restores table (evidence: `Notebook 2.Notebook/notebook-content.py`)
- Read lakehouse tables → DRPOC lakehouse: queries tables (evidence: `DR_Test_Notebook.Notebook/notebook-content.py`)
