No description
Find a file
HAMMOUCHE Hocine 8445d1dd94
All checks were successful
SQL linter / Lint (push) Successful in 44s
fix: version of postgres used
2025-08-18 14:12:49 +02:00
.github/workflows ci: fix create missing folder 2025-08-18 13:46:13 +02:00
analyses Initial commit 2023-08-30 16:34:22 -07:00
data-tests Fix: Missing profiles.yml and whitespace+naming nits (#13) 2024-02-28 20:22:29 -06:00
macros Fabric adapter doesnt work with default cents_to_dollars macro 2024-05-08 16:04:42 +07:00
models style: format SQL queries 2025-08-18 13:21:36 +02:00
seeds Update order dates to be more modern 2025-06-19 09:03:40 +12:00
src/jaffle_shop feat: initialize the project with UV 2025-08-17 16:23:18 +02:00
.gitignore Fix fanout in customers model (#20) 2024-03-29 13:17:40 -05:00
.pre-commit-config.yaml Update project structure (#25) 2024-04-09 18:58:09 -05:00
.python-version feat: initialize the project with UV 2025-08-17 16:23:18 +02:00
.sqlfluff style: format SQL queries 2025-08-18 13:21:36 +02:00
.sqlfluffignore ci: add a workflow to run the SQL linter 2025-08-18 13:03:04 +02:00
dbt_project.yml ci: add a workflow to run the SQL linter 2025-08-18 13:03:04 +02:00
docker-compose.yml fix: version of postgres used 2025-08-18 14:12:49 +02:00
Dockerfile feat: Dockerfile and docker-compose.yml files 2025-08-17 17:28:17 +02:00
package-lock.yml ci: add a workflow to run the SQL linter 2025-08-18 13:03:04 +02:00
packages.yml ci: add a workflow to run the SQL linter 2025-08-18 13:03:04 +02:00
pyproject.toml ci: add a workflow to run the SQL linter 2025-08-18 13:03:04 +02:00
README.md docs: update README.md 2025-08-17 17:28:34 +02:00
requirements.in Update project structure (#25) 2024-04-09 18:58:09 -05:00
requirements.txt Update jafgen which removes pandas dep from requirements.txt 2024-04-13 06:44:05 -05:00
Taskfile.yml Simplify steps to load example data (#83) 2025-05-22 17:37:16 -06:00
uv.lock ci: add a workflow to run the SQL linter 2025-08-18 13:03:04 +02:00

MDPI Assesment Project - Jaffle Shop

How to run the project

The project contain a docker compose file with the PostgreSQL database and a container using the image based on the Dockerfile to initialize the database and run DBT transformations.

You can use the dataset in the repository or generate a new one using the jafgen 10 && rm -rf seeds/jaffle-data && mv jaffle-data seeds command.

The following command will start the database and initialize it when it is ready:

docker compose --profile init up db-init

PS: you can find the profile and initialization script directly in the Dockerfile.