What table has the Rubric Criterion scores?

[lmccain]

We are trying to pull rubric scores into our data lake.  We have been able to locate and pull the outcome scores, but we have not been able to find the regular rubric criterion scores anywhere.

Is it possible to pull the regular criterion scores similarly to the outcome scores?

[stimme]

@lmccain There are three tables for rubrics: rubric_assessments, rubric_associations, rubrics. The columns rubric_assessments.data and rubrics.data contain rubrics' criteria, ratings, scores, and comments in nested JSON objects. In order to have criteria as rows, additional processing will be necessary.

[lmccain]

Thanks for explaining that.  I was looking at this page and not finding what I needed. Your explanation and the link you provided will work for us.

[stimme]

@lmccain Glad to hear it. The page that you linked to documents tables in Canvas Data 1, which was deprecated at the end of 2023. Given that deprecation, I had imagined you had moved to Canvas Data 2 (What is Canvas Data 2? ) and were asking its datasets. Good luck with this implementation!