Canvas 2 Tables

[MeredithAdams]

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

[stimme · Accepted solution]

@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 

[MeredithAdams]

wonderful, thank you so much!

[MeredithAdams]

Hi there! I need access to this for another project involving Canvas tables. Could you please grant me access? I've requested it. Thank you!

[sgergely]

Hello @MeredithAdams!

That document is no longer maintained and does not reflect the current structure or ongoing updates to the CD2 datasets. Since the CD1 sunset last August, we have made several updates to the Canvas dataset and continue to evolve it. Here are some of the most recent changes:

Recent changes in the CD2 Canvas dataset:

• New collaborations table added
  
• Enhancements to the assignments table with:
  
• parent_assignment_id
• type
• has_sub_assignments
• unified_tool_id column going to be added to the context_external_tools table
  
• Numerous new enum values introduced in fields like media_comment_type, workflow_state, file_state, and content_type

The most up-to-date dataset documentation is always available here: https://developerdocs.instructure.com/services/dap/dataset

How you can help

I’d love to understand what you were hoping to find in the old mapping document and how the current documentation can better support you.

• What information or format would make the documentation more useful for you?
  
• Are there specific mappings, comparisons, or schema diagrams that would help you integrate or analyze CD2 data more easily?
  
• What is the timeline you are working with regarding CD1 based data formats?
• Anything else you would like to share?

I’d truly value any thoughts or suggestions you may have—your input will help us improve the documentation for everyone using CD2.