How gojesujal/sql_data_warehouse_project works
This repository implements a PostgreSQL medallion warehouse: source CSV data is loaded into Bronze, cleaned and standardized into Silver, then modeled as Gold customer/product dimensions and a sales fact for analytics. Quality checks cover the warehouse layers, including Gold key uniqueness and fact-to-dimension integrity. The README documents the workflow, but no SQL excerpts were available, so links reflect documented data flow rather than verified statement-level calls.
Main entry points: load_bronze.sql Bronze Loader · bronze_ddl.sql Bronze Tables · silver_ddl.sql Silver Tables · load_silver.sql Silver Transform
Components 10
Bronze Layer
- Bronze Tables
scripts/bronze/bronze_ddl.sql - Bronze Loader
scripts/bronze/load_bronze.sql
Silver Layer
- Silver Tables
scripts/silver/silver_ddl.sql - Silver Transform
scripts/silver/load_silver.sql - Silver Quality Checks
scripts/silver/quality_check_silver.sql
Gold Layer
- Gold Dimensions & Fact
scripts/gold/gold_ddl.sql - Gold Quality Checks
scripts/gold/quality_check_gold.sql
Other components
- Source CSVs
datasets/placeholder - PostgreSQL Warehouse
- Analytics & Reporting
Connections 9
- Bronze Tables → PostgreSQL Warehouse: creates tables
- Source CSVs → Bronze Loader: supplies data
- Bronze Loader → PostgreSQL Warehouse: loads Bronze
- Silver Tables → PostgreSQL Warehouse: creates tables
- Silver Transform → PostgreSQL Warehouse: reads Bronze; writes Silver
- Silver Quality Checks → PostgreSQL Warehouse: checks Silver
- Gold Dimensions & Fact → PostgreSQL Warehouse: reads Silver; builds Gold
- Gold Quality Checks → PostgreSQL Warehouse: checks Gold
- Analytics & Reporting → PostgreSQL Warehouse: queries Gold