How kego-mashigo/kasi-mart-data-engineering-project1 works
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: Query1_Orderdetailjoin.sql Order Detail Join · Query2_Revenuepercustomer.sql Revenue per Customer · Query3_Revenuepercategory.sql Revenue per Category · Query4_Top5customers.sql Top Five Customers
Components 18
Project Data
- Customers CSV
Raw Project Data/customers.csv - Products CSV
Raw Project Data/products.csv - Orders CSV
Raw Project Data/orders.csv
Snowflake Analytics
- Snowflake
- Customers Raw Table
- Products Raw Table
- Orders Raw Table
- Order Detail Join
SQL Queries Codes/Query1_Orderdetailjoin.sql - Revenue per Customer
SQL Queries Codes/Query2_Revenuepercustomer.sql - Revenue per Category
SQL Queries Codes/Query3_Revenuepercategory.sql - Top Five Customers
SQL Queries Codes/Query4_Top5customers.sql
Project Evidence
- Order Detail Results
csv query output/Query1_Orderdetailjoin.csv - Customer Revenue Results
csv query output/Query2_Revenuepercustomer.csv - Category Revenue Results
csv query output/Query3_Revenuepercategory.csv - Top Customer Results
csv query output/Query4_Top5customers.csv - Query Write-up
Quality Writeup/qualitywriteup.txt - Snowflake Screenshots
Screenshots
Other components
- Project Author
Connections 16
- Project Author → Snowflake: loads data
README.md - Customers CSV → Customers Raw Table: loaded as
README.md - Products CSV → Products Raw Table: loaded as
README.md - Orders CSV → Orders Raw Table: loaded as
README.md - Customers Raw Table → Orders Raw Table: customer places orders
README.md - Products Raw Table → Orders Raw Table: product in orders
README.md - Project Author → Order Detail Join: runs query
README.md - Project Author → Revenue per Customer: runs query
README.md - Project Author → Revenue per Category: runs query
README.md - Project Author → Top Five Customers: runs query
README.md - Order Detail Join → Order Detail Results: exports results
README.md - Revenue per Customer → Customer Revenue Results: exports results
README.md - Revenue per Category → Category Revenue Results: exports results
README.md - Top Five Customers → Top Customer Results: exports results
README.md - Project Author → Query Write-up: explains queries
README.md - Project Author → Snowflake Screenshots: captures evidence
README.md