docker compose up -d- Run the queries:
docker exec -i sql_analytics_lab_db psql -U postgres -d analytics < queries/01_dimensional_metrics.sqldocker exec -i sql_analytics_lab_db psql -U postgres -d analytics < queries/02_data_quality_checks.sqldocker exec -i sql_analytics_lab_db psql -U postgres -d analytics < queries/03_performance_notes.sql
- Keep SQL readable (CTEs, clear naming, comments for intent).
- If you change query outputs, update the matching file in
expected_results/. - CI must stay green.