This document relates to the Canvas Data 2 API integration with the CCC Data Warehouse Direct Connect Service.
The table below provides all differences between Instructure data documentation and the integration of Canvas Data 2 in the CCC Data Warehouse Redshift database, including field names, split columns, and possible schema changes.
Table | Original Column Name | Updated Column Name | Type | Notes |
|---|---|---|---|---|
learning_outcome_question_results | percent | _percent | REAL | Redshift considers "percent" a reserved word. |
learning_outcome_results | percent | _percent | REAL | Redshift considers "percent" a reserved word. |
lti_line_items | tag | _tag | VARCHAR | Redshift considers "tag" a reserved word. |
assignment_groups | rules | drop_highest | INTEGER | Denormalized from unsupported object column type. |
assignment_groups | rules | drop_lowest | INTEGER | Denormalized from unsupported object column type. |
assignment_groups | rules | never_drop | VARCHAR | Denormalized from unsupported object column type. |
assignments | turnitin_settings | originality_report_visibility | VARCHAR | Denormalized from unsupported object column type. |
assignments | turnitin_settings | exclude_small_matches_type | VARCHAR | Denormalized from unsupported object column type. |
assignments | turnitin_settings | exclude_small_matches_value | INTEGER | Denormalized from unsupported object column type. |
assignments | turnitin_settings | s_paper_check | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | s_view_report | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | internet_check | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | journal_check | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | exclude_biblio | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | exclude_quoted | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | submit_papers_to | BOOLEAN | Denormalized from unsupported object column type. |
context_external_tools | settings | course_home_sub_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | course_settings_sub_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | custom_fields | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | discussion_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | discussion_topic_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | discussion_topic_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | editor_button | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | enabled | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | file_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | file_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | global_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | grade_passback | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | homework_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | homework_submission | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | launch_presentation_document_target | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | link_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | migration_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | module_group_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | module_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | account_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | assignment_group_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | assignment_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | assignment_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | assignment_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | canvas_caliper_url | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | collaboration | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | content_migration | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | course_assignments_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | course_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | module_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | post_grades | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | quiz_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | quiz_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | similarity_detection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | student_context_card | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | text | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | tool_configuration | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | use_1_3 | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | user_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | visibility | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | wiki_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | wiki_page_menu | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | allow_student_discussion_editing | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | allow_student_discussion_topics | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | course_format | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | filter_speed_grader_by_student_group | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | hide_distribution_graphs | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | hide_final_grade | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | is_public_to_auth_users | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | lock_all_announcements | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | public_syllabus | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | public_syllabus_to_auth | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | restrict_student_future_view | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | restrict_student_past_view | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | syllabus_updated_at | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | usage_rights_required | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | allow_student_forum_attachments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | neutral_comments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | answers | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | name | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_type | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_text | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | regrade_option | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | correct_comments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | incorrect_comments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | text_after_answers | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | matching_answer_incorrect_matches | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | points_possible | REAL | Denormalized from unsupported object column type. |