DODonald Okothinsyntaxray-dataeng.hashnode.dev·Jan 28 · 7 min readSQL Guide: Convert CSV to Star Schema DesignIntroduction The star schema is a data warehouse table design pattern where a single main table contains measurable/ numerical data, and multiple other tables contain descriptive data about the entries in the main table. A fact table is the name give...00
DODonald Okothinsyntaxray-dataeng.hashnode.dev·Jan 23 · 12 min readETL Pipeline Mini Project (Python → Docker → Postgres → Kubernetes)Project aim The main aim of this project, I would say, was to pick up Kubernetes while exercising my Python, Docker, and Postgres muscles. I have always heard of Kubernetes (I don’t feel competent enough to graduate to K8s yet), but I chalked it off ...00