Hello, I have a question about the relationship of the score, kept_score, and fudge_points column in the quiz_submission_historical_fact table. When I was joining the table, I found out a interesting ...

Sorry, a follow-up question. But when I was checking the Canvas database. I notice there is a timestamp associate with unsubmitted action. Then when is the timestamp generated? Is it when the assignme...

Hello. I have a question about the Canvas Data Submission_dim datatable workflow state field, what does it mean when the workflow state is unsubmitted? Because for what I know, canvas doesn't allo...

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 v...

Hello, I have a question about the relationship of the score, kept_score, and fudge_points column in the quiz_submission_historical_fact table. When I was joining the table, I found out a interesting ...

Sorry, a follow-up question. But when I was checking the Canvas database. I notice there is a timestamp associate with unsubmitted action. Then when is the timestamp generated? Is it when the assignme...

Hello. I have a question about the Canvas Data Submission_dim datatable workflow state field, what does it mean when the workflow state is unsubmitted? Because for what I know, canvas doesn't allo...

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 v...