Canvas Data Release Notes (2016-03-24)

Document created by Demi Kureghian Employee on Mar 25, 2016Last modified by Erin Hallmark on Mar 28, 2016
Version 3Show Document
  • View in full screen mode

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.

Attachments

    Outcomes