Canvas 2 Tables

Jump to solution
MeredithAdams
Community Member

The following tables are what are institution uses for Canvas Data 1. I am a business analyst trying to research the difference between these tables with Canvas Data 1 versus 2. My question is, will these tables be titled by the same name in Canvas Data 2?

pseudonym_fact
pseudonym_dim
user_dim
enrollment_fact
enrollment_dim
enrollment_term_dim
course_dim
course_section_dim
assignment_group_fact
assignment_group_dim
assignment_fact
assignment_dim
submission_fact
submission_dim
course_score_fact
course_score_dim

0 Likes
1 Solution
stimme
Community Coach
Community Coach

@MeredithAdams The tables you listed will have similar names, but dim & fact fields are no longer separated into two tables. There's a Google Sheets file that covers CD1 - CD2 equivalences. https://docs.google.com/spreadsheets/d/1kqCXAD9K45L0QeEtbuuMAFp2fW8o0oC8EBzJf58SjrY/edit#gid=0 

View solution in original post

This "CD1 to CD2 mapping" document is one auxiliary item from a larger set of documentation that is offered to Instructure customers in order to assist in understanding the CD2 data schema in relation with the legacy CD1 star schema. It is meant to serve this one-off effort to assist customers in