This PR adds a model, fact_enrollments, which enriches the enrollment_events MV with metadata provided by the course_names lookup table.
If merged, this will allow us to convert the fact_enrollments Superset dataset to a physical dataset. We can also simplify the fact_enrollments_by_day dataset by relying on this model instead of including another jinja template from the Superset assets directory. I've confirmed this model has the same columns as the Superset dataset it's replacing and has columns for all dashboard filters.
This PR also removes two unused enrollments models (they've since moved to the Superset assets directory in tutor-contrib-aspects).
Not that I can tell. Removing the old enrollment models from schema.yml also deletes the tests that were run on that model. Running dbt test locally works for me.
This PR adds a model,
fact_enrollments
, which enriches theenrollment_events
MV with metadata provided by thecourse_names
lookup table.If merged, this will allow us to convert the
fact_enrollments
Superset dataset to a physical dataset. We can also simplify thefact_enrollments_by_day
dataset by relying on this model instead of including another jinja template from the Superset assets directory. I've confirmed this model has the same columns as the Superset dataset it's replacing and has columns for all dashboard filters.This PR also removes two unused enrollments models (they've since moved to the Superset assets directory in tutor-contrib-aspects).