Community

In this Canvas Data release, assignment override tables have been made available for download. Bug fixes are also included. Canvas Data is a service that provides institutions with optimized access to all their data for reporting and queries. Learn more about Canvas Data.   New Features   < BACK TO TABLE OF CONTENTS Portal Assignment Override Tables Four new tables relating to assignment overrides are available for download. The Assignment_Override_fact, assignment_override_user_fact, assignment_override_dim, and assignment_override_user_dim tables can provide insight into assignment override information such as due date overrides, lock date overrides, etc. Complete table descriptions can be found on the Canvas Data Schema Docs page.   Fixed Bugs   < BACK TO TABLE OF CONTENTS CLI Tool Log Error Data is correctly logged when files fail to download. Previously, the program would crash early while attempting to log data if any files had failed to download. Windows Path Separator Downloaded files will not be inadvertently deleted from Windows machines. Previously, a third party module in the CLI was using improper path separators on Windows. This behavior resulted in downloaded files being removed unintentionally. ... View more

In this Catalog Data release,  the schema docs include new tables for files data. A bug fix is also included. 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   < BACK TO TABLE OF CONTENTS Schema Docs File tables Canvas Data Schema Docs include file_fact and file_dim tables, which provide files insight for Canvas accounts.   Fixed Bugs   < BACK TO TABLE OF CONTENTS Schema Docs Column Descriptions The description for the group_category_id column in both the group_dim and group_fact tables have been changed to reflect the group_category_dim table is not yet available. ... View more

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   < BACK TO TABLE OF CONTENTS Schema Docs Whitelisted keys in YAML schemas Users see a new nullable key for each column in the Schema Docs.   Fixed Bugs   < BACK TO TABLE OF CONTENTS 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. ... View more