Canvas Data Lake Access Request
- Praveen Kumar Partheepan
How to get access?
To access Self Service Canvas Data in Silver layer please submit a ticket to it-analytics@usf.edu with the following information
Tables:
Reason for Access:
How to access Self Service Canvas Data in Silver layer?
Server: usfsynapseanalytics-ondemand.sql.azuresynapse.net
Database: Canvas
Tables
Classification | Table name | Table Description |
admin | access_tokens | Stores the access tokens for a user and developer tools. |
admin | account_users | Join table for accounts, users and roles. |
registration | accounts | Stores data about account objects in the Canvas system. |
course content | assessment_question_banks | Stores data about question banks. |
course content | assessment_questions | Stores attributes of a question associated with a quiz. |
course content | assignment_groups | Stores rules associated with an assignment group. |
course content | assignment_override_students | Stores measures related to ad hoc users for whom an assignment override exists. |
course content | assignment_overrides | Stores records for assignment due date overrides. |
course content | assignments | This table stores attributes for assignments |
course content | attachment_associations | Links user files to an assignment to allow grader to see the student's submission. |
course content | attachments | Describes files in Canvas. |
course content | calendar_events | The model for calendar events in Canvas |
course content | canvadocs_annotation_contexts | Launch context associated with DocViewer when assignment is of type Annotated_Document. |
course content | comment_bank_items | Stores user comments that have been added to the comment bank. |
admin | communication_channels | Channels through which a user receives Canvas notifications. |
course content | content_migrations | Saves data about what and when was added to a course through a course copy or import. |
course content | content_participation_counts | Shows students a count of the number of submissions they have that have something unread. |
course content | content_participations | Stores data related to students submission updates or feedback. |
course content | content_shares | Provides a link to a content export from a sender to a receiver. |
course content | content_tags | In the context of LTI, joins context_external_tools to either assignments or to context_modules. |
course content | context_external_tools | Stores data about installed LTI 1 and 1.3 tools |
course content | context_module_progressions | Shows which items a student has completed, started and not started in a module. |
course content | context_modules | Modules in Canvas. |
course content/student submission | conversation_message_participants | The participants in a certain message in a Conversation. |
course content/student submission | conversation_messages | The messages that belong to a certain Conversation, these are in the Inbox. |
course content/student submission | conversation_participants | The participants in a Conversation. |
course content/student submission | conversations | Conversation threads from the Canvas Inbox. |
registration | course_account_associations | An explicit place to keep track of all the the accounts in the account hierarchy that a course belongs to. |
registration | course_sections | Stores attributes for a section of a course. |
registration | courses | Stores attributes for a course. |
course content | custom_gradebook_column_data | Contains per-user data for the custom columns defined in custom_gradebook_columns. |
course content | custom_gradebook_columns | Contains configuration information for custom Gradebook columns defined for specific courses |
admin | developer_key_account_bindings | Joins the accounts table to developer_keys. |
admin | developer_keys | A table representing a set of credentials used for API access. |
student submissions | discussion_entries | Stores attributes for discussion entries. |
course content | discussion_entry_participants | Tracks who has read a particular entry. |
course content | discussion_topic_participants | Links discussion topics to the users who have posted in them. |
course content | discussion_topics | This table stores attributes for discussion topics in Canvas. |
registration | enrollment_dates_overrides | Supports allowing certain roles to have access to a term outside of term date boundaries. |
registration | enrollment_states | Stores the state of an enrollment. |
registration | enrollment_terms | Stores enrollment term records that describe the term or semester associated with courses (e.g. Fall 2013). |
registration | enrollments | This table stores user enrollments. |
admin | favorites | A record of items that a user has favorited, such as a Course |
course content | folders | A collection of files (attachments). |
course content | grading_period_groups | Stores attributes for grading period groups, which are a group of grading periods. |
course content | grading_periods | Stores attributes for grading period. |
course content | grading_standards | Contains data for grading schemes defined for a course or account. |
course content | group_categories | A container for a set of groups, since often you want everyone to be in exactly one group in a set. |
course content | group_memberships | A join table of users and groups. Like enrollments, but for groups instead of courses |
course content | groups | Stores attributes for groups in canvas |
course content | late_policies | Contains late/missing policy configurations for courses |
course content | learning_outcome_groups | Learning outcome groups organize outcomes hierarchically within a context, such as an account, course or the global context. |
course content | learning_outcome_question_results | Attributes for the results of answered questions which have been associated with a learning outcome |
course content | learning_outcome_results | Learning outcome results are a student's mastery score on a given outcome. |
course content | learning_outcomes | Learning outcomes are measurable statements that express student knowledge or a student skill. |
course content | lti_line_items | Represents a line item from the IMS Assignment and Grade service. |
course content | lti_resource_links | Joins context_external_tools to other resources in Canvas (assignments for example). |
course content | lti_results | Represents a result from the IMS Assignment and Grade service |
admin | master_courses_child_content_tags | Links imported course content to the child subscription and keeps track of changes made to content. |
admin | master_courses_child_subscriptions | Saves data about which child courses are linked to which master blueprint courses. |
admin | master_courses_master_content_tags | Links blueprint course content to the template and keeps track of their locked status. |
admin | master_courses_master_migrations | Represents a blueprint course sync event. |
admin | master_courses_master_templates | Stores blueprint course specific data and links a course with all other blueprint models. |
admin | master_courses_migration_results | Stores results for individual associated courses for a blueprint sync event. |
course content | originality_reports | Represents an "originality score" for a submission. |
course content | outcome_proficiencies | Outcome proficiencies, or learning mastery proficiency ratings, define a set of ratings, which together create a point scale and a mastery level. |
course content | outcome_proficiency_ratings | Outcome proficiency ratings define the individual tiers of outcome proficiencies. |
course content | post_policies | Contains post policy configurations for courses and individual assignments. |
admin | pseudonyms | This table stores user pseudonyms |
course content | quiz_groups | This table stores attributes for quiz group. |
course content | quiz_questions | This table stores attributes of a question associated with a quiz. |
student submissions | quiz_submissions | Stores attributes for the last submitted quiz |
course content | quizzes | Stores attributes for quizzes. |
admin | role_overrides | A customization to the default permissions granted by a role. |
registration | roles | A user is assigned a role which grants all the permissions associated with that role. |
course content | rubric_assessments | Shows the data that a teacher has entered in to a rubric while grading a student |
course content | rubric_associations | Links a rubric to an assignment. |
course content | rubrics | List of criteria that describe how an assignment should be graded. |
course content | score_statistics | This table stores aggregate statistics for scores on individual assignments. |
course content | scores | This table stores assignment group and course grades for students enrolled in a course. |
course content | submission_comments | This table contains attributes related to the submission comments feature in Canvas. |
student submissions | submission_versions | This table stores information describing previous versions of individual submission objects. |
student submissions | submissions | This table stores submission records for an assignment. |
admin | user_account_associations | Stores data about user and account relationship, how "close" a user is related to an account. |
course content | user_notes | Stores the data for the Faculty Journal feature. |
registration | users | This table stores attributes for users. |
course content | web_conference_participants | Links users to conferences they are invited to join. |
course content | web_conferences | Data model for Conferences in Canvas. |
course content | wiki_pages | Stores text data that is linked to a wiki and a course. |
course content | wikis | Links a course to its wiki pages. |