How nithinsaichandar/datawarehouseprojectsql works
This repository is a small SQL data-warehouse project. Its tree shows database initialization plus Bronze and Silver DDL and load procedures; the README describes ETL, data modeling, and analytics. No SQL excerpts are available, so the exact execution order and connections between scripts cannot be verified. Analytics is documented but has no identifiable implementation path in the supplied tree.
Components 6
Warehouse foundation
- Initialize database
scripts/init_database.sql
Bronze stage
- Bronze schema
scripts/bronze/ddl_bronze.sql - Bronze loading
scripts/bronze/proc_load_bronze.sql
Silver stage
- Silver schema
scripts/silver/ddl_silver.sql - Silver loading
scripts/silver/proc_load_silver.sql
Analytics
- Analytics capability