Canvas Data Release Notes 2017-09-05

Document created by Cynthia Coan Employee on Sep 5, 2017
Version 1Show Document
  • View in full screen mode

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.