Projects / ETL Data Warehouse
Case studyPublic
Open source
ETL Data Warehouse
A star-schema warehouse fed by an automated pipeline.
Reports off the transactional database, rebuilt safely on every run.
github.com/IgliHoxha

In the picture: Aggregations read straight from the loaded star schema, synthetic data, from the project's README.
- Type
- Open source
- Status
- Public
- Stack
- PHP, Symfony, Doctrine, MariaDB, Docker
- Address
- github.com/IgliHoxha
Why we built it
Reports run on a transactional database slow it down and lie about history.
What it does
An automated Symfony ETL pipeline that builds and refreshes a star-schema warehouse.
How it is built
PHP, Doctrine and MariaDB, all in Docker.
Decisions worth noting
Facts and dimensions are rebuilt idempotently, so a failed run can simply run again.
All projectsOr write to hello@stackrover.tech