Migrate `marts__combined_coursesinprogram` to use dimensional layer

Open Beginner friendly
#2,079 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
78/100
Issue type
Refactor
Clarity
Clearly specified
Activity status
Quiet
Tech stack
sql
Domain
data-engineering

Research direction

Start with src/ol_dbt/models/marts/combined/marts__combined_coursesinprogram.sql and inspect the dimensional models dim_program, bridge_program_course, and dim_course. Replace the six intermediate-model references so only dimensional, mart, or reporting models remain, then run dbt compile and the model's dbt tests. Done means no int__* or stg__* refs remain and compilation and tests pass.

Written by the indexing model from the issue text.

Description

enhancement product:data-platform

Epic: #2072

File: src/ol_dbt/models/marts/combined/marts__combined_coursesinprogram.sql

Problem: Directly references 6 intermediate models for program-course mappings. Target: use dim_program, bridge_program_course, and dim_course 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
Dominant language
Python
Stars
51
Forks
6
Avg merge
2d 19h
Merged PRs (30d)
113

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from mitodl/ol-data-platform

All issues in mitodl/ol-data-platform

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.