Canvas Data Release Notes (2018-02-27)
In this production release of Canvas Data the schema version will be bumped to 2.0.0. Conference and a new file table have been added to the data set along with new fields added to current tables. The new schema has been attached to this post to help accommodate change. This change version will go live on the March 13, 2018 data dump.
The submission_comment_participant_fact and submission_comment_participant_dim tables are being fully removed from the Canvas Data schema. The announcement of the deprecation occurred in the https://community.canvaslms.com/docs/DOC-12323-canvas-data-release-notes-2017-09-05 release notes
- AddedTables
- conference_fact
- conference_dim
- conference_participant_fact
- conference_participant_dim
- submission_file_fact
- Added Columns
- assignment_fact
- assignment_dim
- course_dim
- Removed and Deprecated Tables
- submission_comment_participant_fact
- submission_comment_participant_dim
- score_fact
- score_dim
Added Tables |
conference_fact
Measures for conferences
| Name | Type | Description |
|---|---|---|
| conference_id | bigint | Foreign key to the conference dimension table |
| group_id | bigint | Foreign key to the group if this conference was associated with a group |
| course_id | bigint | Foreign key to the course if this conference was associated with a course |
| account_id | bigint | Foreign key to the account if this conference was associated with an account |
| duration | double precision | Length of conference session |
conference_dim
Attributes for conferences
| Name | Type | Description |
|---|---|---|
| id | bigint | Unique surrogate identifier for the score |
| canvas_id | bigint | Primary key for this conference in the web_conferences table |
| title | varchar256 | The title of the conference |
| conference_type | varchar256 | The type of conference (e.g. BigBlueButton, AdobeConnect) |
| group_id | bigint | Foreign key to the group if this conferences was associated with a group |
| course_id | bigint | Foreign key to the course if this conference was associated with an course |
| account_id | bigint | Foreign key to the account if this conference was associated with an account |
| start_at | timestamp | The time the conference was scheduled to begin |
| started_at | timestamp | The time at which the conference actually started, null if it hasn't started |
| end_at | timestamp | The time at which the conference was scheduled to start |
| ended_at | timestamp | The time at which this conference actually ended, null if it hasn't ended |
| created_at | timestamp | Time when the conference was created |
| updated_at | timestamp | Time when the conference was last updated |
conference_participant_fact
Measures for conference participants
| Name | Type | Description |
|---|---|---|
| conference_participant_id | bigint | Foreign key to the conference participant |
| group_id | bigint | Foreign key to the group if this conference was associated with a group |
| course_id | bigint | Foreign key to the course if this conference was associated with a course |
| account_id | bigint | Foreign key to the account if this conference was associated with an account |
| user_id | bigint | Foreign key to the user who is the conference participant |
| conference_id | bigint | Foreign key to the conference |
conference_participant_dim
Attributes for conference participants
| Name | Type | Description |
|---|---|---|
| id | bigint | Unique surrogate key for a conference participant |
| user_id | bigint | Foreign key to the user who is the conference participant |
| conference_id | bigint | Foreign key to the conference |
| participation_type | varchar256 | Type of participation, ('invitee' or 'attendee' |
| created_at | timestamp | Time when the conference participant was created |
| updated_at | timestamp | Time when the conference participant was last updated |
submission_file_fact
A junction table that associates files and submissions. This table fixed a bug where the submission_id was no longer being populated within the file_dim table which made it impossible to differentiate between assignment files, user files, or course files.
| Name | Type | Description |
|---|---|---|
| submission_file_id | bigint | Unique surrogate key for the file-submission association |
| file_id | bigint | Foreign key to the file in this association |
| submission_id | bigint | Foreign key to the submission in this association |
| assignment_id | bigint | Foreign key to the assignment the submission is associated with |
| user_id | bigint | Foreign key to the user who uploaded this file |
| grader_id | bigint | Foreign key to the user who graded the submission in this assocation |
| course_id | bigint | Foreign key to course associated with the submission. |
| enrollment_term_id | bigint | Foreign key to enrollment term associated with the submission's course |
Added Columns |
assignment_fact
| Name | Type | Description |
|---|---|---|
| external_tool_id | bigint | Foreign key to the external tool activation if this assignment uses an external tool for submissions |
assignment_dim
| Name | Type | Description |
|---|---|---|
| external_tool_id | bigint | Foreign key to the external tool activation if this assignment uses an external tool for submissions |
course_dim
| Name | Type | Description |
|---|---|---|
| syllabus_body | text | Content of the syllabus for this course. |
Removed and Deprecated Tables |
submission_comment_participant_fact
This table is no longer populated in Canvas, and as such is no longer populating current data. The removal and deprecation of this table was announced in thehttps://community.canvaslms.com/docs/DOC-12323-canvas-data-release-notes-2017-09-05
submission_comment_participant_dim
This table is no longer populated in Canvas, and as such is no longer populating current data. The removal and deprecation of this table was announced in the https://community.canvaslms.com/docs/DOC-12323-canvas-data-release-notes-2017-09-05
score_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.
score_dim
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.
