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