In this Data release, an update was made to include a nullable key for each column in YAML schemas. Bug fixes were also included for both Schema Docs and the Canvas Data Portal.
Canvas Data is a service that provides institutions with optimized access to all their data for reporting and queries. Learn more about Canvas Data.
Whitelisted keys in YAML schemas
Users see a new nullable key for each column in the Schema Docs.
Users will be able to see the correct IDs in quiz_submission_dim and fact tables, allowing them to join the other tables with these tables.
- All the grader_id values in submission_dim and fact should be in user_dim.
- Submission_dim.grade_state column has been added to differentiate the auto-graded submissions from human-graded and non-graded submissions.
- Grader_id, group_id, quiz_submission_id and user_id columns have been added to submission_dim and account_id. Assignment_group_id, group_id, quiz_id, quiz_submission_id and wiki_id have been added to submission_fact to make joins easier.
quiz_dim.workflow_state should only have the unpublished value assigned when appropriate.
Correct values are now displayed in quiz_dim.show_correct_answers.
Canvas Data Portal
User List Labels
The labels in the Users list will now follow the naming convention since several typos have been corrected.