I been testing the quiz_submission_dim table and quiz_submission_historical_dim. However from the Canvas data portal doc, the two table should have same quiz but the historical dim will have all the version of submission of that particular quiz while the quiz_submission_dim table have the newest one
The problem is when I create a practice quiz, I found out that that practice quiz submission data are only in quiz_submission_historical_dim table and not in quiz_submission_dim table.
Can anyone tell me why is this happening? Is it just because the practice quiz won't appear in quiz_submission_dim or did I miss something?