Canvas Data 2 Data Modifications for CCC Data Warehouse (Redshift)
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. While this listing attempts to document all the field name changes, It can more generally be stated that if an Original Column Name (from Instructure) is a reserved word in Redshift, then the replication/load process appends an underscore to the field name. Additionally, if Instructure delivers an field that is a rich object; containing multiple subfields, then the replication/load process attempts, where possible to flatten the object and prepends the path name into the column name.
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 | rules_drop_highest | INTEGER | Denormalized from unsupported object column type. |
assignment_groups | rules | rules_drop_lowest | INTEGER | Denormalized from unsupported object column type. |
assignment_groups | rules | rules_never_drop | VARCHAR | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_originality_report_visibility | VARCHAR | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_exclude_small_matches_type | VARCHAR | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_exclude_small_matches_value | INTEGER | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_s_paper_check | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_s_view_report | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_internet_check | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_journal_check | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_exclude_biblio | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_exclude_quoted | BOOLEAN | Denormalized from unsupported object column type. |
assignments | turnitin_settings | turnitin_settings_submit_papers_to | BOOLEAN | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_course_home_sub_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_course_settings_sub_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_custom_fields | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_discussion_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_discussion_topic_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_discussion_topic_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_editor_button | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_enabled | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_file_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | 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 | settings_grade_passback | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_homework_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_homework_submission | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_launch_presentation_document_target | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_link_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_migration_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_module_group_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_module_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_account_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_assignment_group_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_assignment_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_assignment_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_assignment_selection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_canvas_caliper_url | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_collaboration | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_content_migration | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_course_assignments_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_course_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_module_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_post_grades | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_quiz_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_quiz_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_similarity_detection | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_student_context_card | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_text | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_tool_configuration | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_use_1_3 | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_user_navigation | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_visibility | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_wiki_index_menu | VARCHAR | Denormalized from unsupported object column type. |
context_external_tools | settings | settings_wiki_page_menu | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_allow_student_discussion_editing | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_allow_student_discussion_topics | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_course_format | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_filter_speed_grader_by_student_group | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_hide_distribution_graphs | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_hide_final_grade | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_is_public_to_auth_users | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_lock_all_announcements | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_public_syllabus | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_public_syllabus_to_auth | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_restrict_student_future_view | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_restrict_student_past_view | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_syllabus_updated_at | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_usage_rights_required | VARCHAR | Denormalized from unsupported object column type. |
courses | settings | settings_allow_student_forum_attachments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_neutral_comments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_answers | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_name | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_question_type | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_question_text | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_regrade_option | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_correct_comments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_incorrect_comments | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_text_after_answers | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_matching_answer_incorrect_matches | VARCHAR | Denormalized from unsupported object column type. |
quiz_questions | question_data | question_data_points_possible | REAL | Denormalized from unsupported object column type. |