I can get the final quiz score from quiz_submission_fact. But how to query the score for each individual quiz question?
That data is not included natively in the Canvas Data product. There's a report in Canvas called Student Analysis. We use the REST API to download the quiz report and put the data into our own table. It has worked well for us.
It works! Thank you very much!
Retrieving data ...