# toryigithan-blip/sql-datawarehouse-project architecture

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

- Interactive diagram: https://gitdiagram.com/toryigithan-blip/sql-datawarehouse-project
- Repository: https://github.com/toryigithan-blip/sql-datawarehouse-project

## Overview

The documented product is a SQL Server sales data warehouse: ERP/CRM CSV data is loaded into Bronze, cleansed and standardized in Silver, then modeled for analytics in Gold. The checked-in tree contains Bronze and Silver SQL scripts, but no Gold implementation or report files; those documented capabilities are shown without assigning them an unsupported source path. Relationships are based on the README, since no source excerpts were provided.

Main entry points: [`scripts/bronze/proc_load_bronze.sql`](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/bronze/proc_load_bronze.sql) (Bronze loading), [`scripts/silver/proc_load_silver.sql`](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/silver/proc_load_silver.sql) (Silver cleansing)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ingest["Raw ingestion"]
  node_bronze_schema[("Bronze schema<br/>[ddl_bronze.SQL]")]
  node_bronze_load["Bronze loading"]
  node_database_init["Database setup<br/>[init.database.sql]"]
end

subgraph group_transform["Data preparation"]
  node_silver_schema[("Silver schema<br/>[ddl_silver.sql]")]
  node_silver_transform["Silver cleansing"]
end

subgraph group_analytics["Analytics"]
  node_gold_model[("Gold star model")]
  node_analytics_reports["SQL analytics"]
end

node_source_csv["ERP/CRM CSVs"]
node_stakeholders(("Decision-makers"))

node_source_csv -->|"loads raw data"| node_bronze_load
node_bronze_load -->|"cleans and standardizes"| node_silver_transform
node_silver_transform -->|"prepares for modeling"| node_gold_model
node_gold_model -->|"supports reporting"| node_analytics_reports
node_analytics_reports -->|"delivers insights"| node_stakeholders

click node_bronze_schema "https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/bronze/ddl_bronze.SQL"
click node_bronze_load "https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/bronze/proc_load_bronze.sql"
click node_silver_schema "https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/silver/ddl_silver.sql"
click node_silver_transform "https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/silver/proc_load_silver.sql"
click node_database_init "https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/init.database.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_bronze_schema,node_bronze_load,node_database_init toneBlue
class node_silver_schema,node_silver_transform toneAmber
class node_gold_model,node_analytics_reports toneMint
class node_source_csv,node_stakeholders toneIndigo
```

## Components

### Raw ingestion

- [Bronze schema](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/bronze/ddl_bronze.SQL): `scripts/bronze/ddl_bronze.SQL`
- [Bronze loading](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/bronze/proc_load_bronze.sql): `scripts/bronze/proc_load_bronze.sql`
- [Database setup](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/init.database.sql): `scripts/init.database.sql`

### Data preparation

- [Silver schema](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/silver/ddl_silver.sql): `scripts/silver/ddl_silver.sql`
- [Silver cleansing](https://github.com/toryigithan-blip/sql-datawarehouse-project/blob/main/scripts/silver/proc_load_silver.sql): `scripts/silver/proc_load_silver.sql`

### Analytics

- **Gold star model**
- **SQL analytics**

### Other components

- **ERP/CRM CSVs**
- **Decision-makers**

## Connections

- ERP/CRM CSVs → Bronze loading: loads raw data (evidence: `README.md`)
- Bronze loading → Silver cleansing: cleans and standardizes (evidence: `README.md`)
- Silver cleansing → Gold star model: prepares for modeling (evidence: `README.md`)
- Gold star model → SQL analytics: supports reporting (evidence: `README.md`)
- SQL analytics → Decision-makers: delivers insights (evidence: `README.md`)
