# haiderabbasi6357-cloud/sql-datawarehouse-project architecture

> Architecture diagram of the GitHub repository haiderabbasi6357-cloud/sql-datawarehouse-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/haiderabbasi6357-cloud/sql-datawarehouse-project
- Repository: https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project
- Video tour (about a minute): https://gitdiagram.com/haiderabbasi6357-cloud/sql-datawarehouse-project/video

## Overview

This is a SQL Server ETL warehouse: raw CRM and ERP CSVs are loaded into Bronze, transformed in Silver, and modeled as a Gold star schema for BI and SQL reporting. The README documents these relationships and data-quality checks; no source excerpts were available, so the graph uses documented capabilities and tree-supported paths without inferring finer-grained SQL calls.

Main entry points: [`tests/checks`](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/tests/checks) (Data Quality Checks), [`scripts/bronze/procedure_load`](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/bronze/procedure_load) (Bronze Load), [`scripts/bronze/table_defining`](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/bronze/table_defining) (Bronze Tables), [`scripts/silver/silver_ddl`](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/silver/silver_ddl) (Silver Tables)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sources["Source Data"]
  node_crm["CRM CSVs"]
  node_erp["ERP CSVs"]
end

subgraph group_etl["ETL Layers"]
  node_bronze_load["Bronze Load"]
  node_bronze_tables["Bronze Tables"]
  node_silver_clean["Silver Cleaning"]
  node_silver_ddl["Silver Tables"]
end

subgraph group_analytics["Warehouse And Quality"]
  node_gold_views["Gold Analytics"]
  node_warehouse[("Analytics Warehouse")]
  node_quality["Data Quality Checks"]
end

node_reporting(("BI And SQL Reporting"))

node_crm -->|"bulk loads"| node_bronze_load
node_erp -->|"bulk loads"| node_bronze_load
node_bronze_load -->|"loads raw data"| node_bronze_tables
node_bronze_tables -->|"cleans and transforms"| node_silver_clean
node_silver_clean -->|"standardizes data"| node_silver_ddl
node_silver_ddl -->|"models data"| node_gold_views
node_gold_views -->|"publishes star schema"| node_warehouse
node_warehouse -->|"serves analytics"| node_reporting
node_quality -->|"validates"| node_bronze_tables
node_quality -->|"validates"| node_silver_ddl
node_quality -->|"validates"| node_warehouse

click node_crm "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/tree/main/datasets/source_crm"
click node_erp "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/tree/main/datasets/source_erp"
click node_bronze_load "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/bronze/procedure_load"
click node_bronze_tables "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/bronze/table_defining"
click node_silver_clean "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/silver/Cleaning%20Raw%20Data"
click node_silver_ddl "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/silver/silver_ddl"
click node_gold_views "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/gold/Analytic%20Views"
click node_quality "https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/tests/checks"

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_crm,node_erp toneBlue
class node_bronze_load,node_bronze_tables,node_silver_clean,node_silver_ddl toneAmber
class node_gold_views,node_warehouse,node_quality toneMint
class node_reporting toneIndigo
```

## Components

### Source Data

- [CRM CSVs](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/tree/main/datasets/source_crm): `datasets/source_crm`
- [ERP CSVs](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/tree/main/datasets/source_erp): `datasets/source_erp`

### ETL Layers

- [Bronze Load](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/bronze/procedure_load): `scripts/bronze/procedure_load`
- [Bronze Tables](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/bronze/table_defining): `scripts/bronze/table_defining`
- [Silver Cleaning](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/silver/Cleaning%20Raw%20Data): `scripts/silver/Cleaning Raw Data`
- [Silver Tables](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/silver/silver_ddl): `scripts/silver/silver_ddl`

### Warehouse And Quality

- [Gold Analytics](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/scripts/gold/Analytic%20Views): `scripts/gold/Analytic Views`
- **Analytics Warehouse**
- [Data Quality Checks](https://github.com/haiderabbasi6357-cloud/sql-datawarehouse-project/blob/main/tests/checks): `tests/checks`

### Other components

- **BI And SQL Reporting**

## Connections

- CRM CSVs → Bronze Load: bulk loads
- ERP CSVs → Bronze Load: bulk loads
- Bronze Load → Bronze Tables: loads raw data
- Bronze Tables → Silver Cleaning: cleans and transforms
- Silver Cleaning → Silver Tables: standardizes data
- Silver Tables → Gold Analytics: models data
- Gold Analytics → Analytics Warehouse: publishes star schema
- Analytics Warehouse → BI And SQL Reporting: serves analytics
- Data Quality Checks → Bronze Tables: validates
- Data Quality Checks → Silver Tables: validates
- Data Quality Checks → Analytics Warehouse: validates