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 Name | Column Type | Description |
---|---|---|
global_canvas_id | BIGINT | This 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 Name | Column Type | Description |
---|---|---|
last_activity_at | timestamp | Last 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.