Community

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     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. ... View more

In this production release of Canvas Data, we have bumped to schema version 1.18.0 and have added a new set of score tables. The new schema has been attached to this post to help accommodate change. This change version will go live in January 23rd's data dump. New tables have been added to the Canvas Data Schema to help clarify scores that belong to an assignment group, course, or grading period. The score_fact and score_dim tables are also being deprecated in order to accommodate the new score tables for more accurate reporting.   Added Tables assignment_group_score_fact Table containing measures for Assignment Group scores within Canvas grade book Name Type Description score_id bigint Unique surrogate identifier for the score. canvas_id bigint Primary key for the score account_id bigint Foreign key to the Account group table. course_id bigint Foreign key to the Course group table. assignment_group_id double precision Foreign key to the Assignment group table. enrollment_id bigint Foreign key to the Enrollment table. current_score double precision Current score final_score double precision Final score muted_current_score double precision Current Score that might not yet be public. Or is muted muted_final_score double precision Final score that might not yet be public. Or is muted course_score_fact Table containing measures for overall course scores within Canvas grade book Name Type Description score_id bigint Unique surrogate identifier for the score canvas_id bigint Primary key for the score account_id bigint Foreign key to the Account group table course_id bigint Foreign key to the Course group table enrollment_id bigint Foreign key to the Enrollment table current_score double precision Current score final_score double precision Final score muted_current_score double precision Current Score that might not yet be public, or is muted muted_final_score double precision Final score that might not yet be public, or is muted grading_period_score_fact Table containing measures for Grading Period scores within Canvas grade book Name Type Description score_id bigint Unique surrogate identifier for the score canvas_id bigint Primary key for the score account_id bigint Foreign key to the Account group table course_id bigint Foreign key to the Course group table enrollment_id bigint Foreign key to the Enrollment table grading_period_id bigint Foreign key to the grading period group table grading_period_group_id bigint Foreign key to the grading period group table grading_period_group_account_id bigint One hop ID to the Account table for the grading period group table current_score double precision Current score final_score double precision Final score muted_current_score double precision Current Score that might not yet be public, or is muted muted_final_score double precision Final score that might not yet be public, or is muted assignment_group_score_dim Attributes for Assignment Group scores. You can think of a score as synonymous with a cell inside the gradebook Name Type Description id bigint Unique surrogate identifier for the score canvas_id bigint Primary key for the score assignment_group_id bigint Foreign key to the assignment group table enrollment_id bigint Foreign key to the Enrollment table created_at timestamp Timestamp when record was created updated_at timestamp Timestamp when record was last updated workflow_state varchar workflow state for the score. Possible values are 'active', 'deleted' course_score_dim Attributes for course scores. You can think of a score as synonymous with a cell inside the gradebook. Name Type Description id bigint Unique surrogate identifier for the  score canvas_id bigint Primary key for the score enrollment_id bigint Foreign key to the Enrollment table created_at timestamp Timestamp when record was created updated_at timestamp Timestamp when record was last updated workflow_state varchar workflow state for the score.  Possible values are 'active', 'deleted' grading_period_score_dim Attributes for Grading Period scores. You can think of a score as synonymous with a cell inside the gradebook. Name Type Description id bigint Unique surrogate identifier for the  score canvas_id bigint Primary key for the score enrollment_id bigint Foreign key to the Enrollment table grading_period_id bigint Foreign key to the grading period group table created_at timestamp Timestamp when record was created updated_at timestamp Timestamp when record was last updated workflow_state varchar workflow state for the score.  Possibe values are 'active', 'deleted'   Changed Tables 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. ... View more