mitodl / mitodl/ol-data-platform
Migrate `problem_engagement_detail_report` to use dimensional layer
Open
Beginner friendly
Nobody has claimed this yet.
enhancement
product:data-platform
- Dominant language
- Python
- Stars
- 51
- Forks
- 6
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 113
Description
Epic: #2072
File: src/ol_dbt/models/reporting/problem_engagement_detail_report.sql
Problem: References int__combined__course_runs directly alongside dimensional models. Target: replace with dim_course_run.
Acceptance criteria:
- Model references only
dimensional/, mart, or reporting models - No
{{ ref('int__*') }}or{{ ref('stg__*') }}calls remain - Model compiles and passes dbt tests
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with src/ol_dbt/models/reporting/problem_engagement_detail_report.sql and inspect its ref to int__combined__course_runs alongside the existing dimensional references. Update the model to use dim_course_run, then run dbt compilation and tests; it is done when no int__* or stg__* refs remain and the acceptance criteria pass.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- data-engineering
- Issue type
- Refactor
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Quiet
- Clarity
- Clearly specified
- Newbie friendliness
- 78/100