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

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.