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

Delete legacy TRREB dbt models (staging, intermediate, mart) #48

New Issue
Closed
opened 2026-01-16 14:54:08 +00:00 by lmiranda · 0 comments
lmiranda commented 2026-01-16 14:54:08 +00:00
Owner
Copy Link

Description

Remove all TRREB-related dbt models that are obsolete after transitioning to the neighbourhood-centric data model.

Branch: feature/9-cleanup

Reference: docs/changes/Change-Toronto-Analysis-Reviewed.md - Phase 1

Files to DELETE

File Reason
dbt/models/staging/stg_trreb__purchases.sql TRREB staging obsolete
dbt/models/intermediate/int_purchases__monthly.sql TRREB intermediate obsolete
dbt/models/marts/mart_toronto_purchases.sql Will rebuild for neighbourhood grain

Files to MODIFY

File Action
dbt/models/sources.yml Remove TRREB source definitions
dbt/models/schema.yml Remove TRREB model documentation

Acceptance Criteria

  • All three TRREB dbt model files deleted
  • sources.yml has no TRREB source references
  • schema.yml has no TRREB model documentation
  • dbt compile succeeds without errors (may have warnings about missing models until new ones created)
  • dbt parse shows no orphaned references

Technical Notes

  • CMHC-related dbt models should be preserved (stg_cmhc__rentals, etc.)
  • The new neighbourhood-centric marts will be created in a future sprint (Phase 4)
  • Check for any dbt tests that reference these models

Sprint

Sprint 9 - Phase 1 (Cleanup)

Labels: Type/Refactor, Priority/High, Efforts/S, Component/Database, Tech/PostgreSQL

## Description Remove all TRREB-related dbt models that are obsolete after transitioning to the neighbourhood-centric data model. **Branch:** `feature/9-cleanup` **Reference:** `docs/changes/Change-Toronto-Analysis-Reviewed.md` - Phase 1 ## Files to DELETE | File | Reason | |------|--------| | `dbt/models/staging/stg_trreb__purchases.sql` | TRREB staging obsolete | | `dbt/models/intermediate/int_purchases__monthly.sql` | TRREB intermediate obsolete | | `dbt/models/marts/mart_toronto_purchases.sql` | Will rebuild for neighbourhood grain | ## Files to MODIFY | File | Action | |------|--------| | `dbt/models/sources.yml` | Remove TRREB source definitions | | `dbt/models/schema.yml` | Remove TRREB model documentation | ## Acceptance Criteria - [ ] All three TRREB dbt model files deleted - [ ] `sources.yml` has no TRREB source references - [ ] `schema.yml` has no TRREB model documentation - [ ] `dbt compile` succeeds without errors (may have warnings about missing models until new ones created) - [ ] `dbt parse` shows no orphaned references ## Technical Notes - CMHC-related dbt models should be preserved (stg_cmhc__rentals, etc.) - The new neighbourhood-centric marts will be created in a future sprint (Phase 4) - Check for any dbt tests that reference these models ## Sprint Sprint 9 - Phase 1 (Cleanup) **Labels:** Type/Refactor, Priority/High, Efforts/S, Component/Database, Tech/PostgreSQL
lmiranda added this to the Launch: Host, Bio and Toronto House Market Analysis project 2026-01-16 14:55:49 +00:00
lmiranda self-assigned this 2026-01-16 14:55:54 +00:00
lmiranda moved this to To Do in Launch: Host, Bio and Toronto House Market Analysis on 2026-01-16 14:56:00 +00:00
lmiranda moved this to Done in Launch: Host, Bio and Toronto House Market Analysis on 2026-01-16 15:33:50 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
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 Launch: Host, Bio and Toronto House Market Analysis
Assignees
Clear assignees
lmiranda
No Assignees lmiranda
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: personal-projects/personal-portfolio#48
Delete Branch "%!s()"

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?