mitodl / mitodl/ol-data-platform
Migrate `marts__mitxonline_course_engagements_daily` 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/marts/mitxonline/marts__mitxonline_course_engagements_daily.sql
Problem: References 6 mitxonline intermediate models directly. Target: use dim_course_run, dim_user, and activity fact tables from the dimensional layer.
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/marts/mitxonline/marts__mitxonline_course_engagements_daily.sql and trace the dimensional models dim_course_run, dim_user, and the activity fact tables. Replace the six intermediate-model references with dimensional, mart, or reporting references. Done means no int__* or stg__* refs remain, and the model compiles and passes dbt tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- data-engineering
- Issue type
- Refactor
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Clearly specified
- Newbie friendliness
- 72/100