Migrate `learner_demographics_and_cert_info` to use dimensional layer (blocked by mart migration)

Open
#2,116 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
35/100
Issue type
Refactor
Clarity
Mostly clear
Activity status
Quiet
Tech stack
sql
Domain
data-engineering

Research direction

Start with src/ol_dbt/models/reporting/learner_demographics_and_cert_info.sql and review the upstream mart migrations that currently block this work. After those migrations are complete, check the model and its upstream mart dependencies for remaining int__* or stg__* refs. Run dbt compile and dbt tests; done means the model uses only dimensional, mart, or reporting models and passes validation.

Written by the indexing model from the issue text.

Description

enhancement product:data-platform

Epic: #2072

File: src/ol_dbt/models/reporting/learner_demographics_and_cert_info.sql

Problem: References 4 mart models instead of dimensional models. Blocked by migration of those marts.

Note: This issue is blocked by the migration of the upstream mart model(s) it references. It should be addressed after those mart migrations are complete.

Acceptance criteria:

  • Model references only dimensional/, mart, or reporting models (all of which use dimensional)
  • No {{ ref('int__*') }} or {{ ref('stg__*') }} calls remain in this model or its upstream mart dependencies
  • 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.