Canvas Data Release Notes (2017-03-02)

Document created by Eric Coan Employee on Mar 2, 2017
Version 1Show Document
  • View in full screen mode

In this production release (March 2nd), we have updated the schema to version v1.16.0. Changes to the schema for this release include adding extra fields to assignments, and exporting group level discussions instead of just course level discussions. We've also started mapping message lengths of 0 in the discussion dim to their proper "0".

 

 

  Added Columns

 

Assignment DIM

 

Column NameColumn TypeDescription
visibilityENUMUser sets that can view the assignment. Possible values ('everyone', 'only_visible_to_overrides').

 

Discussion Topic DIM

 

Column NameColumn TypeDescription
course_idBIGINTForeign key to the course dimension.
group_idBIGINTForeign key to the group dimension.

 

Discussion Topic FACT

 

Column NameColumn TypeDescription
group_idBIGINTForeign key to the group dimension.
group_parent_course_idBIGINTForeign key to course dimension.
group_parent_account_idBIGINTForeign key to accounts table.
group_parent_course_account_idBIGINTForeign key to the account dimension for the account associated with the course to which the group belongs to.

 

 

  Changed Descriptions

 

Discussion Topic FACT

 

Column NameColumn TypeDescription
message_lengthINTBest guess at the count of characters in the message. Special characters are treated differently in different systems. As a result, you may find variance in message length in your own systems. NULL messages are mapped to 0 length.
1 person found this helpful

Attachments

    Outcomes