Skip to main content
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Canvas Data Release Notes (2017-03-02)

Canvas Data Release Notes (2017-03-02)

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.
Was this article helpful? Yes No
Embed this guide in your Canvas course:

Note: You can only embed guides in Canvas courses. Embedding on other sites is not supported.