Canvas Data Release Notes (2016-03-24)
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.
Features |
Schema Docs
Whitelisted keys in YAML schemas
Users see a new nullable key for each column in the Schema Docs.
Fixed Bugs |
Schema Docs
Quiz_submission_id
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.
Submission_fact.grader_id
- 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 always
quiz_dim.workflow_state should only have the unpublished value assigned when appropriate.
Quiz_dim.show_correct_answers
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.