{"id":28830,"date":"2026-06-07T05:51:18","date_gmt":"2026-06-07T05:51:18","guid":{"rendered":"https:\/\/www.cloudthat.com\/training\/?post_type=stm-courses&p=28830"},"modified":"2026-06-11T12:46:33","modified_gmt":"2026-06-11T12:46:33","slug":"migrating-amazon-redshift-users-to-bigquery","status":"publish","type":"stm-courses","link":"https:\/\/www.cloudthat.com\/training\/google-cloud-certification\/migrating-amazon-redshift-users-to-bigquery","title":{"rendered":"Migrating Amazon Redshift Users to BigQuery"},"content":{"rendered":"

This instructor-led course introduces learners to migrating data warehouse workloads from Amazon Redshift to\u00a0BigQuery\u00a0on Google Cloud. Participants will explore how Amazon Redshift concepts translate into\u00a0BigQuery\u00a0equivalents and understand the differences in architecture, resource management, schema optimization, and SQL workflows.<\/span>\u00a0<\/span><\/p>\n

The course covers\u00a0BigQuery\u00a0architecture, datasets and tables, resource provisioning, data type mapping, schema migration strategies, partitioning, clustering, and SQL translation techniques. Learners will also gain hands-on experience migrating schemas and translating SQL workloads from Amazon Redshift to\u00a0BigQuery.<\/span>\u00a0<\/span><\/p>\n

Through guided labs, demonstrations, and migration-focused implementation exercises, participants will build foundational skills required for planning and executing Amazon Redshift to BigQuery migrations.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

This instructor-led course introduces learners to migrating data warehouse workloads from Amazon Redshift to\u00a0BigQuery\u00a0on Google Cloud. Participants will explore how Amazon Redshift concepts translate into\u00a0BigQuery\u00a0equivalents and understand the differences in architecture, resource management, schema optimization, and SQL workflows.\u00a0 The course covers\u00a0BigQuery\u00a0architecture, datasets and tables, resource provisioning, data type mapping, schema migration strategies, partitioning, clustering, and […]<\/p>\n","protected":false},"author":6436,"featured_media":28795,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[58],"metadata":{"stm_lms_product_id":["28831"],"_edit_lock":["1781181877:6767"],"_edit_last":["6767"],"permalink_customizer":["google-cloud-certification\/migrating-amazon-redshift-users-to-bigquery"],"permalink_customizer_regenerate_status":["1"],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"course_banner_image":[""],"_course_banner_image":["field_63c69a6b81cf1"],"mobile_banner_image":[""],"_mobile_banner_image":["field_63cf93896d207"],"banner_link":[""],"_banner_link":["field_63c69a9681cf2"],"banner_image":[""],"_banner_image":["field_621873548f922"],"banner_description":["Learn how to migrate data warehouse workloads from Amazon Redshift to BigQuery by understanding architecture differences, schema mapping, SQL translation, data type conversion, and resource provisioning on Google Cloud. "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":["Course Overview of Migrating Amazon Redshift Users to BigQuery "],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing Migrating Amazon Redshift Users to BigQuery, students will be able to: "],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course":["10"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Key Features of Migrating Amazon Redshift Users to BigQuery "],"_key_features_heading":["field_645388ceffdd1"],"key_features":["8"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who Should Attend Migrating Amazon Redshift Users to BigQuery?"],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend":["7"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["Prerequisites of Migrating Amazon Redshift Users to BigQuery "],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["

  • Experience using Amazon Redshift for managing data warehouses and SQL analysis\r\n
  • Basic SQL knowledge \r\n
  • Basic familiarity with BigQuery is recommended but not mandatory \r\n
  • Interest in cloud analytics migration workflows "],"_prerequisites_text":["field_612c7498c4b84"],"question_sets_details_heading":[""],"_question_sets_details_heading":["field_65d303841f38d"],"question_sets_details_description":[""],"_question_sets_details_description":["field_65d303841f38e"],"question_sets_details_button_text":[""],"_question_sets_details_button_text":["field_65d303841f38f"],"question_sets_details_question_sets":[""],"_question_sets_details_question_sets":["field_65d303841f390"],"question_sets_details":[""],"_question_sets_details":["field_65d303841f38c"],"category_features_heading":[""],"_category_features_heading":["field_644b8ff35049c"],"category_features_features":[""],"_category_features_features":["field_644b90025049d"],"category_features_cta_text":[""],"_category_features_cta_text":["field_644b90285049f"],"category_features_cta_link":[""],"_category_features_cta_link":["field_644b902d504a0"],"category_features":[""],"_category_features":["field_644b8fe15049b"],"course_features_0_heading":["Why Choose CloudThat as your Training Partner for Migrating Amazon Redshift Users to BigQuery?"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list":["8"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:5:\"white\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features_1_heading":["Learning Objectives for Migrating Amazon Redshift Users to BigQuery "],"_course_features_1_heading":["field_644a0fae0e67e"],"course_features_1_features_list":["1"],"_course_features_1_features_list":["field_644a0fb70e67f"],"course_features_1_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_1_background_color":["field_644a0fde0e681"],"course_features":["2"],"_course_features":["field_644a0fa10e67d"],"certification_heading":["Certification Details of Migrating Amazon Redshift Users to BigQuery "],"_certification_heading":["field_64538bffffdd5"],"certification":["1"],"_certification":["field_6103ab1a2822b"],"about_trainer":[""],"_about_trainer":["field_6103ab6c2822f"],"course_fee_heading":[""],"_course_fee_heading":["field_64538c1cffdd6"],"course_fee_list":[""],"_course_fee_list":["field_6103abb728234"],"brochure_pdf":[""],"_brochure_pdf":["field_61232e258f89b"],"trainer":[""],"_trainer":["field_6124990e13784"],"course_outline_heading":["Course Outline for Migrating Amazon Redshift Users to BigQuery "],"_course_outline_heading":["field_64538a8effdd4"],"course_section":["5"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":[""],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["1987"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.9"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":["FAQs for Migrating Amazon Redshift Users to BigQuery "],"_faq_heading":["field_64538c59ffdd8"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"curriculum":[""],"featured":[""],"views":["22"],"level":["beginner"],"current_students":["0"],"duration_info":["1 Day"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["57950"],"sale_price":[""],"sale_price_dates":[""],"enterprise_price":[""],"not_membership":[""],"affiliate_course":[""],"affiliate_course_text":[""],"affiliate_course_link":[""],"expiration_course":[""],"end_time":[""],"drip_content":[""],"prerequisites":[""],"prerequisite_passing_level":[""],"announcement":[""],"faq":["[{\"question\":\"Who is this course intended for?\",\"answer\":\"This course is designed for Amazon Redshift users, data engineers, DBAs, and analytics professionals planning to migrate workloads to BigQuery. \"},{\"question\":\"Do I need prior BigQuery experience?\",\"answer\":\"No. Basic familiarity with BigQuery is recommended but not required. \"},{\"question\":\"What topics are covered in this course?\",\"answer\":\"The course covers BigQuery architecture, schema migration, SQL translation, partitioning, clustering, resource management, and data type mapping. \"},{\"question\":\"Is this a hands-on course?\",\"answer\":\"Yes. The course includes practical labs for BigQuery resource provisioning, schema migration, and SQL translation. \"},{\"question\":\"What Google Cloud services are included?\",\"answer\":\"BigQuery, BigQuery SQL, BigQuery Slots, partitioning, and clustering features. \"},{\"question\":\"Does the course cover SQL migration?\",\"answer\":\"Yes. Learners will translate SELECT, DML, DDL, UDFs, and procedures from Amazon Redshift to BigQuery SQL. \"},{\"question\":\"Will schema optimization be covered?\",\"answer\":\"Yes. The course includes partitioning, clustering, and schema optimization strategies for BigQuery workloads. \"},{\"question\":\"What is the course format?\",\"answer\":\"1-day instructor-led training with lectures, labs, migration exercises, quizzes, and demonstrations. \"},{\"question\":\"Will I receive a certificate?\",\"answer\":\"Yes. A CloudThat Course Completion Certificate will be awarded after successful completion of the training. \"},{\"question\":\"Is this course suitable for beginners?\",\"answer\":\"Yes. This is an introductory-level course designed for professionals beginning their migration journey from Amazon Redshift to BigQuery. \"}]"],"course_files_pack":[""],"course_certificate":[""],"type":[""],"video_type":[""],"presto_player_idx":[""],"lesson_video":[""],"lesson_video_poster":[""],"lesson_video_width":[""],"lesson_shortcode":[""],"lesson_embed_ctx":[""],"lesson_youtube_url":[""],"lesson_stream_url":[""],"lesson_vimeo_url":[""],"lesson_ext_link_url":[""],"duration":[""],"preview":[""],"lesson_excerpt":[""],"lesson_files_pack":[""],"questions":[""],"quiz_style":[""],"duration_measure":[""],"correct_answer":[""],"passing_grade":[""],"re_take_cut":[""],"random_questions":[""],"answers":[""],"question_explanation":[""],"question_view_type":[""],"review_course":[""],"review_user":[""],"review_mark":[""],"order":[""],"absolute":[""],"sticky":[""],"sticky_threshold":[""],"sticky_threshold_color":[""],"stm_agenda":[""],"stm_host":[""],"stm_select_approved_denied":[""],"stm_multiselect_approved":[""],"stm_multiselect_denied":[""],"stm_date":[""],"stm_time":[""],"stm_timezone":[""],"stm_duration":[""],"stm_password":[""],"stm_waiting_room":[""],"stm_join_before_host":[""],"stm_host_join_start":[""],"stm_start_after_participants":[""],"stm_mute_participants":[""],"stm_enforce_login":[""],"stm_alternative_hosts":[""],"author_id":[""],"emails":[""],"wpdocs-meta-bdt":["57950"],"wpdocs-meta-gbp":["599"],"wpdocs-meta-rand":["13255"],"wpdocs-meta-aed":["2932"],"wpdocs-meta-usd":["799"],"offline_price":[""],"offline-bdt":[""],"offline-gbp":[""],"offline-rand":[""],"offline-aed":[""],"offline-usd":[""],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["58"],"_yoast_wpseo_content_score":["90"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"after_completing_course_0_desciption":["Compare Amazon Redshift and BigQuery architectures. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Understand compute and storage separation in BigQuery. "],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Configure datasets and tables in BigQuery. "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Map Amazon Redshift data types to BigQuery data types. "],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Optimize schemas for BigQuery workloads. "],"_after_completing_course_4_desciption":["field_6103ad2f9f5b2"],"after_completing_course_5_desciption":["Implement partitioning and clustering in BigQuery. "],"_after_completing_course_5_desciption":["field_6103ad2f9f5b2"],"after_completing_course_6_desciption":["Translate SQL queries from Amazon Redshift to BigQuery SQL. "],"_after_completing_course_6_desciption":["field_6103ad2f9f5b2"],"after_completing_course_7_desciption":["Understand workload management concepts in BigQuery. "],"_after_completing_course_7_desciption":["field_6103ad2f9f5b2"],"after_completing_course_8_desciption":["Create UDFs and procedures in BigQuery SQL. "],"_after_completing_course_8_desciption":["field_6103ad2f9f5b2"],"after_completing_course_9_desciption":[" Build migration workflows from Amazon Redshift to BigQuery. "],"_after_completing_course_9_desciption":["field_6103ad2f9f5b2"],"key_features_0_lists":["\u00a0Amazon Redshift to\u00a0BigQuery\u00a0Migration Fundamentals<\/span><\/b>\u00a0<\/span>"],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["\u00a0Hands-On Learning Experience<\/span><\/b>\u00a0<\/span>"],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["BigQuery\u00a0Architecture and Resource Management<\/span><\/b>\u00a0<\/span>"],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Schema Migration and Optimization<\/span><\/b>\u00a0<\/span>"],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["SQL Translation Workflows<\/span><\/b>\u00a0<\/span>"],"_key_features_4_lists":["field_6103ad559f5b3"],"key_features_5_lists":["Data Type Mapping and Transformation<\/span><\/b>"],"_key_features_5_lists":["field_6103ad559f5b3"],"key_features_6_lists":["Google Cloud Analytics Ecosystem Exposure<\/span><\/b>\u00a0<\/span>"],"_key_features_6_lists":["field_6103ad559f5b3"],"key_features_7_lists":["Beginner-Friendly Migration Enablement<\/span><\/b>\u00a0<\/span>"],"_key_features_7_lists":["field_6103ad559f5b3"],"course_features_0_features_list_0_list":["Specialized GCP Analytics and Migration Expertise- <\/span><\/b>CloudThat\u00a0specializes in cloud analytics and migration technologies and delivers focused Google Cloud training programs with practical migration implementation experience.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["Industry-Recognized Trainers- <\/span><\/b>Our trainers are certified Google Cloud professionals with\u00a0expertise\u00a0in\u00a0BigQuery, cloud data warehouse migrations, analytics modernization, and SQL optimization.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Hands-On Learning Approach- <\/span><\/b>CloudThat\u00a0emphasizes practical learning through guided labs, schema migration exercises, SQL translation workflows, and migration optimization scenarios.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["Customized Learning Paths- <\/span><\/b>Training programs are designed for database administrators, analytics professionals, cloud engineers, and developers transitioning from Amazon Redshift to\u00a0BigQuery.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["\u00a0Interactive Learning Experience- <\/span><\/b>Sessions include demonstrations, collaborative migration activities, troubleshooting workflows, quizzes, and interactive discussions.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"course_features_0_features_list_5_list":["Placement Assistance and Career Support- <\/span><\/b>CloudThat\u00a0supports learners with cloud analytics migration learning paths, interview preparation, and practical implementation guidance.<\/span>\u00a0<\/span>"],"_course_features_0_features_list_5_list":["field_644a0fc80e680"],"course_features_0_features_list_6_list":["Continuous Learning and Updates- <\/span><\/b>Course content is continuously updated to align with the latest advancements in\u00a0BigQuery, cloud analytics modernization, and migration best practices.<\/span>"],"_course_features_0_features_list_6_list":["field_644a0fc80e680"],"course_features_0_features_list_7_list":["Positive Reviews and Testimonials- <\/span><\/b>Thousands of professionals and enterprises trust\u00a0CloudThat\u00a0for advanced cloud, analytics, migration, and Google Cloud training programs.<\/span>"],"_course_features_0_features_list_7_list":["field_644a0fc80e680"],"course_features_1_features_list_0_list":["This course enables learners to understand how to migrate data warehouse workloads from Amazon Redshift to\u00a0<\/span>BigQuery<\/span>\u00a0by translating architectures, schemas, SQL queries, and optimization strategies into Google Cloud-native analytics workflows.<\/span><\/span>\u00a0<\/span>"],"_course_features_1_features_list_0_list":["field_644a0fc80e680"],"certification_0_short_description":[""],"_certification_0_short_description":["field_6103ab2f2822c"],"certification_0_list_content":["CloudThat Course Completion Certificate will be awarded to all learners who complete the training. "],"_certification_0_list_content":["field_6103ab4a2822d"],"certification_0_image":["28701"],"_certification_0_image":["field_6103ab5b2822e"],"who_should_attend_0_attend_lists":["Database Administrators "],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_1_attend_lists":["Data Engineers "],"_who_should_attend_1_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_2_attend_lists":["Data Analysts "],"_who_should_attend_2_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_3_attend_lists":["Cloud Engineers "],"_who_should_attend_3_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_4_attend_lists":["Analytics Professionals "],"_who_should_attend_4_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_5_attend_lists":["Amazon Redshift Users migrating to BigQuery "],"_who_should_attend_5_attend_lists":["field_6103adfb3f3e4"],"who_should_attend_6_attend_lists":["Professionals involved in cloud data warehouse modernization"],"_who_should_attend_6_attend_lists":["field_6103adfb3f3e4"],"course_section_0_module_title":["Understanding BigQuery Architecture"],"_course_section_0_module_title":["field_612f5535940c3"],"course_section_0_module_description":[""],"_course_section_0_module_description":["field_612f564c921af"],"course_section_0_section_0_title":["Lecture Content "],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["Quick Reminder of Amazon Redshift Architecture"],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Overview of BigQuery Architecture"],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Separation of Compute and Storage in BigQuery"],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_3_lession_title":["BigQuery Slots"],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_4_lession_title":["Workload Management in BigQuery"],"_course_section_0_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["5"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section_1_title":["Learning Objectives "],"_course_section_0_section_1_title":["field_612f5233b0278"],"course_section_0_section_1_lesson_list_0_lession_title":["Compare Amazon Redshift and BigQuery architectures"],"_course_section_0_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_1_lession_title":["Understand BigQuery workload management concepts"],"_course_section_0_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_2_lession_title":["Describe the role of BigQuery Slots"],"_course_section_0_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list_3_lession_title":["Explore compute and storage separation in BigQuery"],"_course_section_0_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list":["4"],"_course_section_0_section_1_lesson_list":["field_612f530a0ac40"],"course_section_0_section":["2"],"_course_section_0_section":["field_612f51e6b0277"],"course_section_1_module_title":["Creating Datasets and Tables in BigQuery "],"_course_section_1_module_title":["field_612f5535940c3"],"course_section_1_module_description":[""],"_course_section_1_module_description":["field_612f564c921af"],"course_section_1_section_0_title":["Lecture Content "],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Resource Hierarchy in Amazon Redshift"],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Resource Hierarchy in BigQuery"],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Creating Resources in BigQuery"],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_3_lession_title":["Sharing Resources in BigQuery"],"_course_section_1_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["4"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Learning Objectives "],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Understand resource hierarchy in BigQuery"],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_1_lession_title":["Configure datasets and tables in BigQuery"],"_course_section_1_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_2_lession_title":["Create and manage resources in BigQuery"],"_course_section_1_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list_3_lession_title":["Share datasets and tables securely"],"_course_section_1_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["4"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section_2_title":["Lab Content "],"_course_section_1_section_2_title":["field_612f5233b0278"],"course_section_1_section_2_lesson_list_0_lession_title":["Provisioning and Managing Resources in BigQuery"],"_course_section_1_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_2_lesson_list":["1"],"_course_section_1_section_2_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["3"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Mapping Data Types from Amazon Redshift to BigQuery"],"_course_section_2_module_title":["field_612f5535940c3"],"course_section_2_module_description":[""],"_course_section_2_module_description":["field_612f564c921af"],"course_section_2_section_0_title":["Lecture Content "],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Mapping Data Types from Amazon Redshift to BigQuery"],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Data Types Unique to BigQuery"],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Data Type Compatibility Workflows"],"_course_section_2_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list":["3"],"_course_section_2_section_0_lesson_list":["field_612f530a0ac40"],"course_section_2_section_1_title":["Learning Objectives "],"_course_section_2_section_1_title":["field_612f5233b0278"],"course_section_2_section_1_lesson_list_0_lession_title":["Map Amazon Redshift data types to BigQuery"],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_1_lession_title":["Understand BigQuery-specific data types"],"_course_section_2_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_2_lession_title":["Handle data compatibility during migrations"],"_course_section_2_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list_3_lession_title":["Explore best practices for schema conversion"],"_course_section_2_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list":["4"],"_course_section_2_section_1_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["2"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["Schema Optimization and Mapping"],"_course_section_3_module_title":["field_612f5535940c3"],"course_section_3_module_description":[""],"_course_section_3_module_description":["field_612f564c921af"],"course_section_3_section_0_title":["Lecture Content "],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["Schema Definitions in BigQuery"],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Partitioning in BigQuery"],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Clustering in BigQuery"],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_3_lession_title":["Schema Optimization Workflows"],"_course_section_3_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["4"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_title":["Learning Objectives "],"_course_section_3_section_1_title":["field_612f5233b0278"],"course_section_3_section_1_lesson_list_0_lession_title":["Define optimized schemas in BigQuery"],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_1_lession_title":["Implement partitioning and clustering strategies"],"_course_section_3_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_2_lession_title":["Optimize migrated schemas for analytics workloads"],"_course_section_3_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list_3_lession_title":["Improve query performance in BigQuery"],"_course_section_3_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list":["4"],"_course_section_3_section_1_lesson_list":["field_612f530a0ac40"],"course_section_3_section_2_title":["Lab Content "],"_course_section_3_section_2_title":["field_612f5233b0278"],"course_section_3_section_2_lesson_list_0_lession_title":["Schema Migration to BigQuery"],"_course_section_3_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_2_lesson_list":["1"],"_course_section_3_section_2_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["3"],"_course_section_3_section":["field_612f51e6b0277"],"course_section_4_module_title":["SQL Translation from Amazon Redshift to BigQuery"],"_course_section_4_module_title":["field_612f5535940c3"],"course_section_4_module_description":[""],"_course_section_4_module_description":["field_612f564c921af"],"course_section_4_section_0_title":["Lecture Content "],"_course_section_4_section_0_title":["field_612f5233b0278"],"course_section_4_section_0_lesson_list_0_lession_title":["SELECT Statements"],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_1_lession_title":["DML Statements"],"_course_section_4_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_2_lession_title":["DDL Statements"],"_course_section_4_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_3_lession_title":["UDFs and Procedures"],"_course_section_4_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_4_lession_title":["Query Translation Workflows"],"_course_section_4_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["5"],"_course_section_4_section_0_lesson_list":["field_612f530a0ac40"],"course_section_4_section_1_title":["Learning Objectives "],"_course_section_4_section_1_title":["field_612f5233b0278"],"course_section_4_section_1_lesson_list_0_lession_title":["Translate SQL queries from Amazon Redshift to BigQuery"],"_course_section_4_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list_1_lession_title":["Use BigQuery SQL for analytics workflows"],"_course_section_4_section_1_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list_2_lession_title":["Create UDFs and procedures in BigQuery"],"_course_section_4_section_1_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list_3_lession_title":["Understand SQL syntax and feature differences"],"_course_section_4_section_1_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list":["4"],"_course_section_4_section_1_lesson_list":["field_612f530a0ac40"],"course_section_4_section_2_title":["Lab Content "],"_course_section_4_section_2_title":["field_612f5233b0278"],"course_section_4_section_2_lesson_list_0_lession_title":["Writing SQL for BigQuery "],"_course_section_4_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_2_lesson_list":["1"],"_course_section_4_section_2_lesson_list":["field_612f530a0ac40"],"course_section_4_section":["3"],"_course_section_4_section":["field_612f51e6b0277"],"_thumbnail_id":["28795"]},"acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28830"}],"collection":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses"}],"about":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/types\/stm-courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/users\/6436"}],"version-history":[{"count":11,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28830\/revisions"}],"predecessor-version":[{"id":29445,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/28830\/revisions\/29445"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/28795"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=28830"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=28830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}