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

Canvas Data Release Notes 2017-09-05

Canvas Data Release Notes 2017-09-05

In this production release of Canvas Data we have bumped to schema version 1.17.0, This change will go live in September 19ths dump. In this production release, we add a field to the Users Table to export the Global IDs for users, deprecate the submission_comment_participant_fact, and add last_activity_at to the enrollment_dim table.

  Added Columns

User DIM

 

Column NameColumn TypeDescription
global_canvas_idBIGINTThis is the global ID of the user within the Canvas System. It is made up of the Internal Shard ID, and the regular user Canvas ID. This is especially useful for live events, or other API Scripts that use Global IDs.

Enrollment DIM

 

Column NameColumn TypeDescription
last_activity_attimestampLast time the enrolled user viewed content or took action in the enrolled course

  Changed Tables

Submission Comment Participant Fact

This table is no longer populated in Canvas, and as such is no longer populating current data. This will be removed in a future version of Canvas Data, and all consumers should move off of this.

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.