syntaxray-dataeng.hashnode.devSQL 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...Jan 28·7 min read
syntaxray-dataeng.hashnode.devETL 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 ...Jan 23·12 min read