personal-projects/personal-portfolio
Template
1
1
Fork 0
Code Issues 3 Pull Requests Actions Packages Projects 1 Releases Wiki Activity

feat: Sprint 4 - Loaders and dbt models #17

Merged
lmiranda merged 1 commits from feature/sprint4-loaders-dbt into development 2026-01-11 21:08:01 +00:00
Conversation 0 Commits 1 Files Changed 22 +1320
lmiranda commented 2026-01-11 21:07:53 +00:00
Owner
Copy Link

Summary

Loaders

  • base.py: Session management, bulk insert, upsert utilities
  • dimensions.py: Load time, district, zone, neighbourhood, policy dimensions
  • trreb.py: Load TRREB purchase data to fact_purchases
  • cmhc.py: Load CMHC rental data to fact_rentals

dbt Project

  • Project configuration (dbt_project.yml, packages.yml)
  • Staging models for all fact and dimension tables
  • Intermediate models with dimension enrichment
  • Marts: purchase analysis, rental analysis, market summary

Closes #16

## Summary ### Loaders - base.py: Session management, bulk insert, upsert utilities - dimensions.py: Load time, district, zone, neighbourhood, policy dimensions - trreb.py: Load TRREB purchase data to fact_purchases - cmhc.py: Load CMHC rental data to fact_rentals ### dbt Project - Project configuration (dbt_project.yml, packages.yml) - Staging models for all fact and dimension tables - Intermediate models with dimension enrichment - Marts: purchase analysis, rental analysis, market summary Closes #16
lmiranda added 1 commit 2026-01-11 21:07:53 +00:00
feat: add loaders and dbt models for Toronto housing data 457bb49395 
Sprint 4 implementation:

Loaders:
- base.py: Session management, bulk insert, upsert utilities
- dimensions.py: Load time, district, zone, neighbourhood, policy dimensions
- trreb.py: Load TRREB purchase data to fact_purchases
- cmhc.py: Load CMHC rental data to fact_rentals

dbt Project:
- Project configuration (dbt_project.yml, packages.yml)
- Staging models for all fact and dimension tables
- Intermediate models with dimension enrichment
- Marts: purchase analysis, rental analysis, market summary

Closes #16

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
lmiranda merged commit b7907e68e4 into development 2026-01-11 21:08:01 +00:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
Clear labels
Complexity/Complex
High uncertainty or many dependencies
 Complexity/Medium
Some unknowns or dependencies
 Complexity/Simple
Straightforward, well-understood
 Effort/L
3-5 days
 Effort/M
1-2 days
 Effort/S
2-4 hours
 Effort/XL
> 1 week
 Effort/XS
< 2 hours
 Priority/Critical
Immediate attention required
 Priority/High
Important, needs attention soon
 Priority/Low
Nice to have, can wait
 Priority/Medium
Normal priority
 Type/Bug
Something isn't working
 Type/Chore
Maintenance tasks
 Type/Documentation
Documentation improvements
 Type/Feature
New feature or request
 Type/Refactor
Code refactoring without changing behavior
 Type/Test
Testing related
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
lmiranda
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: personal-projects/personal-portfolio#17
Delete Branch "feature/sprint4-loaders-dbt"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?