I was trying to create some analytics around quiz submissions across multiple courses, but I noted that quiz_submission_dim and _fact don't match. Delving deeper I find that submissions to quizzes that are not graded assignments are only included in the dim but not the fact table. (Some stats below)
Is this an inherent bug in Canvas Data? Of course I can find those missing records in quiz_submission_historical_fact but just wanted to make sure if this insight is correct.
@ryucali After comparing the records in quiz_dim, quiz_submission_dim, and quiz_submission_fact, I can confirm that the quiz_submission_fact table leaves out the submissions that have no submission_id values, which are the practice_quiz and ungraded survey quizzes. This quirk surprised me, too, when I noticed it. The documentation in Canvas Data Portal doesn't make it clear that there is this inconsistency between the two tables.