mitodl / mitodl/ol-data-platform
Migrate `engagement_problem_completion_raw` to use dimensional layer
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 51
- Forks
- 6
- Avg merge
- 2d 19h
- Merged PRs (30d)
- 113
Description
Epic: #2072
File: src/ol_dbt/models/reporting/engagement_problem_completion_raw.sql
Problem: References int__combined__course_runs directly alongside dimensional models. Target: replace the intermediate reference 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/engagement_problem_completion_raw.sql and inspect its reference to int__combined__course_runs alongside the dimensional models. Replace the intermediate reference with dim_course_run, then run dbt compilation and tests for the model. Done means the model references only dimensional, mart, or reporting models and contains no int__ or stg__ refs.
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
- 82/100