# kego-mashigo/kasi-mart-data-engineering-project1 architecture

> Architecture diagram of the GitHub repository kego-mashigo/kasi-mart-data-engineering-project1, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/kego-mashigo/kasi-mart-data-engineering-project1
- Repository: https://github.com/kego-mashigo/kasi-mart-data-engineering-project1

## Overview

This repository documents a Snowflake-based data-engineering project: provided customer, product, and order CSVs are loaded as raw tables, queried, and exported as results, with a write-up and screenshots serving as evidence. The README establishes the raw-table roles and the four query/result pairs. SQL contents and load statements are not available here, so the graph does not assert which tables each query reads or detail the loading mechanism.

Main entry points: [`SQL Queries Codes/Query1_Orderdetailjoin.sql`](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query1_Orderdetailjoin.sql) (Order Detail Join), [`SQL Queries Codes/Query2_Revenuepercustomer.sql`](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query2_Revenuepercustomer.sql) (Revenue per Customer), [`SQL Queries Codes/Query3_Revenuepercategory.sql`](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query3_Revenuepercategory.sql) (Revenue per Category), [`SQL Queries Codes/Query4_Top5customers.sql`](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query4_Top5customers.sql) (Top Five Customers)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Project Data"]
  node_customers_csv["Customers CSV<br/>[customers.csv]"]
  node_products_csv["Products CSV<br/>[products.csv]"]
  node_orders_csv["Orders CSV<br/>[orders.csv]"]
end

subgraph group_warehouse["Snowflake Analytics"]
  node_snowflake[("Snowflake")]
  node_customers_raw[("Customers Raw Table")]
  node_products_raw[("Products Raw Table")]
  node_orders_raw[("Orders Raw Table")]
  node_query1["Order Detail Join"]
  node_query2["Revenue per Customer"]
  node_query3["Revenue per Category"]
  node_query4["Top Five Customers"]
end

subgraph group_evidence["Project Evidence"]
  node_output1["Order Detail Results"]
  node_output2["Customer Revenue Results"]
  node_output3["Category Revenue Results"]
  node_output4["Top Customer Results"]
  node_writeup["Query Write-up<br/>[qualitywriteup.txt]"]
  node_screenshots["Snowflake Screenshots"]
end

node_author(("Project Author"))

node_author -->|"loads data"| node_snowflake
node_customers_csv -->|"loaded as"| node_customers_raw
node_products_csv -->|"loaded as"| node_products_raw
node_orders_csv -->|"loaded as"| node_orders_raw
node_customers_raw -->|"customer places orders"| node_orders_raw
node_products_raw -->|"product in orders"| node_orders_raw
node_author -->|"runs query"| node_query1
node_author -->|"runs query"| node_query2
node_author -->|"runs query"| node_query3
node_author -->|"runs query"| node_query4
node_query1 -->|"exports results"| node_output1
node_query2 -->|"exports results"| node_output2
node_query3 -->|"exports results"| node_output3
node_query4 -->|"exports results"| node_output4
node_author -->|"explains queries"| node_writeup
node_author -->|"captures evidence"| node_screenshots

click node_customers_csv "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Raw%20Project%20Data/customers.csv"
click node_products_csv "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Raw%20Project%20Data/products.csv"
click node_orders_csv "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Raw%20Project%20Data/orders.csv"
click node_query1 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query1_Orderdetailjoin.sql"
click node_query2 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query2_Revenuepercustomer.sql"
click node_query3 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query3_Revenuepercategory.sql"
click node_query4 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query4_Top5customers.sql"
click node_output1 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query1_Orderdetailjoin.csv"
click node_output2 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query2_Revenuepercustomer.csv"
click node_output3 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query3_Revenuepercategory.csv"
click node_output4 "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query4_Top5customers.csv"
click node_writeup "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Quality%20Writeup/qualitywriteup.txt"
click node_screenshots "https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/tree/main/Screenshots"

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_customers_csv,node_products_csv,node_orders_csv toneBlue
class node_snowflake,node_customers_raw,node_products_raw,node_orders_raw,node_query1,node_query2,node_query3,node_query4 toneAmber
class node_output1,node_output2,node_output3,node_output4,node_writeup,node_screenshots toneMint
class node_author toneIndigo
```

## Components

### Project Data

- [Customers CSV](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Raw%20Project%20Data/customers.csv): `Raw Project Data/customers.csv`
- [Products CSV](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Raw%20Project%20Data/products.csv): `Raw Project Data/products.csv`
- [Orders CSV](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Raw%20Project%20Data/orders.csv): `Raw Project Data/orders.csv`

### Snowflake Analytics

- **Snowflake**
- **Customers Raw Table**
- **Products Raw Table**
- **Orders Raw Table**
- [Order Detail Join](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query1_Orderdetailjoin.sql): `SQL Queries Codes/Query1_Orderdetailjoin.sql`
- [Revenue per Customer](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query2_Revenuepercustomer.sql): `SQL Queries Codes/Query2_Revenuepercustomer.sql`
- [Revenue per Category](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query3_Revenuepercategory.sql): `SQL Queries Codes/Query3_Revenuepercategory.sql`
- [Top Five Customers](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/SQL%20Queries%20Codes/Query4_Top5customers.sql): `SQL Queries Codes/Query4_Top5customers.sql`

### Project Evidence

- [Order Detail Results](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query1_Orderdetailjoin.csv): `csv query output/Query1_Orderdetailjoin.csv`
- [Customer Revenue Results](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query2_Revenuepercustomer.csv): `csv query output/Query2_Revenuepercustomer.csv`
- [Category Revenue Results](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query3_Revenuepercategory.csv): `csv query output/Query3_Revenuepercategory.csv`
- [Top Customer Results](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/csv%20query%20output/Query4_Top5customers.csv): `csv query output/Query4_Top5customers.csv`
- [Query Write-up](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/blob/main/Quality%20Writeup/qualitywriteup.txt): `Quality Writeup/qualitywriteup.txt`
- [Snowflake Screenshots](https://github.com/kego-mashigo/kasi-mart-data-engineering-project1/tree/main/Screenshots): `Screenshots`

### Other components

- **Project Author**

## Connections

- Project Author → Snowflake: loads data (evidence: `README.md`)
- Customers CSV → Customers Raw Table: loaded as (evidence: `README.md`)
- Products CSV → Products Raw Table: loaded as (evidence: `README.md`)
- Orders CSV → Orders Raw Table: loaded as (evidence: `README.md`)
- Customers Raw Table → Orders Raw Table: customer places orders (evidence: `README.md`)
- Products Raw Table → Orders Raw Table: product in orders (evidence: `README.md`)
- Project Author → Order Detail Join: runs query (evidence: `README.md`)
- Project Author → Revenue per Customer: runs query (evidence: `README.md`)
- Project Author → Revenue per Category: runs query (evidence: `README.md`)
- Project Author → Top Five Customers: runs query (evidence: `README.md`)
- Order Detail Join → Order Detail Results: exports results (evidence: `README.md`)
- Revenue per Customer → Customer Revenue Results: exports results (evidence: `README.md`)
- Revenue per Category → Category Revenue Results: exports results (evidence: `README.md`)
- Top Five Customers → Top Customer Results: exports results (evidence: `README.md`)
- Project Author → Query Write-up: explains queries (evidence: `README.md`)
- Project Author → Snowflake Screenshots: captures evidence (evidence: `README.md`)
