Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

All the MicroMasters program data should flow into int__micromasters__* tables #916

Open
rachellougee opened this issue Nov 6, 2023 · 0 comments
Open

All the MicroMasters program data should flow into int__micromasters__* tables #916

rachellougee opened this issue Nov 6, 2023 · 0 comments
Labels
product:data-platform Issues related to the Data Platform product

Comments

@rachellougee
Copy link
Contributor

rachellougee commented Nov 6, 2023 •
edited
Loading

Description/Context

Currently, DEDP program data are in int__micromasters__* tables. But any non DEDP program will not be in these MicroMasters intermediate tables, so it would require code changes if any new MicroMasters program added to MITx Online database in the near future.

Since we've added program_type in raw__mitxonline__app__postgres__courses_program, which identify any MicroMasters program. We should be able to modify these subqueries to include all MicroMasters programs, not just DEDP.

Plan/Design

All MicroMasters program data should be in these tables

  • int__micromasters__course_certificates
  • int__micromasters__course_grades
  • int__micromasters__program_certificates
@rachellougee rachellougee mentioned this issue Nov 6, 2023
Merged
@rachellougee rachellougee self-assigned this Jan 5, 2024
@rachellougee rachellougee removed their assignment Feb 22, 2024
@pdpinch pdpinch added the product:data-platform Issues related to the Data Platform product label Jul 11, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
product:data-platform Issues related to the Data Platform product
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@pdpinch @rachellougee