How sanketb04/data-warehousing-using-postgressql- works
Project type and purpose
• This is a data-engineering project implementing a modern data warehouse on PostgreSQL.
• It follows the Medallion Architecture (Bronze → Silver → Gold) to ingest raw CSV data, cleanse and standardize it, then produce business-ready star schemas for reporting.
File structure
• Top-level directories:
• datasets/ (raw CSV inputs from ERP and CRM)
• scripts/bronze, /silver, /gold (ETL layers)
• tests/ (SQL queries validating Silver and Gold outputs)
• Key configuration: init_database.sql to set up schemas.
• Each layer directory contains DDL (schema definitions) and stored-procedure scripts for loading/transformation.
README for additional insights
• Confirms purpose: build data warehouse, perform ETL, model star schemas, run analytics.
Elements
• Clear labels: “datasets/erp/*.csv”, “Bronze Schema”, “Silver Schema”, “Gold Schema”, “Analytics Queries”
• Star schema (centered star or node graph in gold block)