openedx / aspects-dbt

The dbt project for Open edX Aspects!
Apache License 2.0
2 stars 4 forks source link

Add accuracy tests against a known-good dataset #102

Open bmtcril opened 1 month ago

bmtcril commented 1 month ago

As the schema settles, we should add more testing around making sure the calculations performed in this repo are good / don't accidentally break with future updates. I think the following is a good start, but am open to better ideas:

Where possible it would be great if the tests can be assumed to work outside of the known-good dataset, in which case we should exclude marking them with the ci tag.

saraburns1 commented 1 month ago

examples of queries to test: A simple one would be something like the fact_enrollments model, which should just have the most recent enrollment status joined with the user data. The far other end is fact_video_watched_segments which tries to find how many times each 5 second section of a video was watched