{"id":22664,"date":"2024-10-15T06:07:39","date_gmt":"2024-10-15T06:07:39","guid":{"rendered":"https:\/\/www.cloudthat.com\/training\/?post_type=stm-courses&#038;p=22664"},"modified":"2025-03-19T07:12:30","modified_gmt":"2025-03-19T07:12:30","slug":"orchestrate-bigquery-workloads-with-dataform","status":"publish","type":"stm-courses","link":"https:\/\/www.cloudthat.com\/training\/google-cloud-certification\/orchestrate-bigquery-workloads-with-dataform","title":{"rendered":"Orchestrate BigQuery Workloads with Dataform"},"content":{"rendered":"<p>Dataform is a service for data analysts to develop, test, version control, and schedule complex SQL workflows for data transformation in BigQuery. In this course you will explore the components of Dataform core, learn how to define tables and dependencies in SQLX, document BigQuery tables and views, understand BigQuery security settings and how to manage these with Dataform, write assertions, execute SQL workflows, and explore additional advanced use cases<strong>.<\/strong><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dataform is a service for data analysts to develop, test, version control, and schedule complex SQL workflows for data transformation in BigQuery. In this course you will explore the components of Dataform core, learn how to define tables and dependencies in SQLX, document BigQuery tables and views, understand BigQuery security settings and how to manage [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":13797,"template":"","meta":{"footnotes":""},"stm_lms_course_taxonomy":[58],"metadata":{"stm_lms_product_id":["22665"],"_edit_lock":["1742368396:2"],"_edit_last":["2"],"permalink_customizer":["google-cloud-certification\/orchestrate-bigquery-workloads-with-dataform"],"permalink_customizer_regenerate_status":["1"],"popular_course":["0"],"_popular_course":["field_64253688bc2e5"],"educational_schema":[""],"_educational_schema":["field_652fbbf6f589a"],"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":["Dataform is a platform designed for data analysts to create, test, manage version control, and schedule intricate SQL workflows for data transformation in BigQuery  "],"_banner_description":["field_612c733ed3564"],"overview_section_heading":[""],"_overview_section_heading":["field_64538867ffdd0"],"after_completing_course_heading":["After completing the Orchestrate BigQuery Workloads with Dataform course, students will be able to: "],"_after_completing_course_heading":["field_645c78ade3f50"],"after_completing_course":["6"],"_after_completing_course":["field_6103aae828228"],"key_features_heading":["Orchestrate BigQuery Workloads with Dataform: Key Features:  "],"_key_features_heading":["field_645388ceffdd1"],"key_features":["5"],"_key_features":["field_6103aaff28229"],"who_should_attend_heading":["Who can participate in the training Orchestrate BigQuery Workloads with Dataform? "],"_who_should_attend_heading":["field_645388faffdd2"],"who_should_attend":["1"],"_who_should_attend":["field_6103ab0d2822a"],"prerequisites_heading":["What are the prerequisites for the training?"],"_prerequisites_heading":["field_64538a51ffdd3"],"prerequisites_text":["<li>Knowledge of SQL data analysis and BigQuery as discussed in BigQuery for Data Analysis <\/li>"],"_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":["Learning objective of the course:"],"_course_features_0_heading":["field_644a0fae0e67e"],"course_features_0_features_list":["5"],"_course_features_0_features_list":["field_644a0fb70e67f"],"course_features_0_background_color":["a:1:{i:0;s:4:\"blue\";}"],"_course_features_0_background_color":["field_644a0fde0e681"],"course_features":["1"],"_course_features":["field_644a0fa10e67d"],"certification_heading":[""],"_certification_heading":["field_64538bffffdd5"],"certification":[""],"_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":["Modules covered in the course Orchestrate BigQuery Workloads with Dataform"],"_course_outline_heading":["field_64538a8effdd4"],"course_section":["7"],"_course_section":["field_612f4f27b0276"],"note_section":[""],"_note_section":["field_616d3ed46bbd2"],"popular_sort":[""],"_popular_sort":["field_6172496402af3"],"related_courses":["a:3:{i:0;s:4:\"8287\";i:1;s:5:\"11538\";i:2;s:5:\"19118\";}"],"_related_courses":["field_61c453ca6b2dd"],"reviews_heading":[""],"_reviews_heading":["field_64538c39ffdd7"],"review_rating":[""],"_review_rating":["field_62a813a92bee6"],"total_review_count":["1029"],"_total_review_count":["field_62b002d8d2de5"],"average_review_count":["4.5"],"_average_review_count":["field_62b00367d2de6"],"faq_heading":[""],"_faq_heading":["field_64538c59ffdd8"],"curriculum":[""],"featured":[""],"views":["652"],"level":["intermediate"],"current_students":["0"],"duration_info":["1 Day"],"video_duration":[""],"status":[""],"status_dates":[""],"not_single_sale":[""],"price":["19900"],"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\":\"What is Dataform?\",\"answer\":\"Dataform is a platform that allows data analysts to manage data transformation workflows in SQL, enabling them to develop, test, and schedule complex workflows in BigQuery.\"},{\"question\":\"How does Dataform integrate with BigQuery?\",\"answer\":\"Dataform directly connects to BigQuery, allowing users to define tables, manage dependencies, and execute SQL workflows seamlessly within the BigQuery environment.\"},{\"question\":\"Can I version control my Dataform projects?\",\"answer\":\"Yes, Dataform integrates with GitHub and GitLab, allowing you to version control your SQL code and collaborate with your team effectively.\"},{\"question\":\"What is SQLX?\",\"answer\":\"SQLX is a SQL-based language used in Dataform that allows you to define tables, dependencies, and documentation for your data transformations.\"},{\"question\":\"How can I document my BigQuery tables in Dataform?\",\"answer\":\"Dataform provides features to document tables and views directly in your SQLX code, making it easier to maintain clear and accessible documentation.\"},{\"question\":\"Are there any security features in Dataform?\",\"answer\":\"Yes, Dataform allows you to manage BigQuery security settings, enabling you to control access to your data and workflows effectively.\"},{\"question\":\"How do I write assertions in Dataform?\",\"answer\":\"You can write assertions in Dataform to validate data quality by creating checks that will be executed as part of your workflow.\\n\\n\"},{\"question\":\"What are some advanced use cases for Dataform?\",\"answer\":\"Advanced use cases include building complex data transformation pipelines, integrating with other data tools, and automating data workflows for large-scale data processing.\"}]"],"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":["25999"],"wpdocs-meta-gbp":["349"],"wpdocs-meta-usd":["399"],"_yoast_wpseo_content_score":["90"],"_yoast_wpseo_estimated-reading-time-minutes":["1"],"_yoast_wpseo_wordproof_timestamp":[""],"course_section_0_module_title":["Dataform Core Components"],"_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":["Topics"],"_course_section_0_section_0_title":["field_612f5233b0278"],"course_section_0_section_0_lesson_list_0_lession_title":["SQL workflow"],"_course_section_0_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_1_lession_title":["Repositories and workspaces"],"_course_section_0_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_2_lession_title":["Default files and folders"],"_course_section_0_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list_3_lession_title":["Compiled graphs"],"_course_section_0_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_0_section_0_lesson_list":["4"],"_course_section_0_section_0_lesson_list":["field_612f530a0ac40"],"course_section_0_section_1_title":["Objectives"],"_course_section_0_section_1_title":["field_612f5233b0278"],"course_section_0_section_1_lesson_list_0_lession_title":["Understand the components of Dataflow core. "],"_course_section_0_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_0_section_1_lesson_list":["1"],"_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":["Table Definitions and Dependencies"],"_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":["Topics"],"_course_section_1_section_0_title":["field_612f5233b0278"],"course_section_1_section_0_lesson_list_0_lession_title":["Declare a data source. "],"_course_section_1_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_1_lession_title":["Create a table. "],"_course_section_1_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_2_lession_title":["Create an incremental table. "],"_course_section_1_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_3_lession_title":["Set partitioning and clustering options."],"_course_section_1_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_4_lession_title":["Create an empty table. "],"_course_section_1_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_5_lession_title":["Create an external BigLake table. "],"_course_section_1_section_0_lesson_list_5_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_6_lession_title":["Create views and materialized views. "],"_course_section_1_section_0_lesson_list_6_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list_7_lession_title":["Define dependencies."],"_course_section_1_section_0_lesson_list_7_lession_title":["field_612f533b0ac41"],"course_section_1_section_0_lesson_list":["8"],"_course_section_1_section_0_lesson_list":["field_612f530a0ac40"],"course_section_1_section_1_title":["Objectives"],"_course_section_1_section_1_title":["field_612f5233b0278"],"course_section_1_section_1_lesson_list_0_lession_title":["Create tables and views in BigQuery using Dataform"],"_course_section_1_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_1_section_1_lesson_list":["1"],"_course_section_1_section_1_lesson_list":["field_612f530a0ac40"],"course_section_1_section":["2"],"_course_section_1_section":["field_612f51e6b0277"],"course_section_2_module_title":["Document BigQuery Tables and Views"],"_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":["Topics"],"_course_section_2_section_0_title":["field_612f5233b0278"],"course_section_2_section_0_lesson_list_0_lession_title":["Use column descriptions"],"_course_section_2_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_1_lession_title":["Use globally defined JavaScript constants"],"_course_section_2_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_2_section_0_lesson_list_2_lession_title":["Add labels"],"_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":["Objectives"],"_course_section_2_section_1_title":["field_612f5233b0278"],"course_section_2_section_1_lesson_list_0_lession_title":["Document BigQuery tables and views"],"_course_section_2_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_1_lesson_list":["1"],"_course_section_2_section_1_lesson_list":["field_612f530a0ac40"],"course_section_2_section_2_title":["Activities"],"_course_section_2_section_2_title":["field_612f5233b0278"],"course_section_2_section_2_lesson_list_0_lession_title":["1 lab"],"_course_section_2_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_2_section_2_lesson_list":["1"],"_course_section_2_section_2_lesson_list":["field_612f530a0ac40"],"course_section_2_section":["3"],"_course_section_2_section":["field_612f51e6b0277"],"course_section_3_module_title":["BigQuery Security Settings"],"_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":["Topics"],"_course_section_3_section_0_title":["field_612f5233b0278"],"course_section_3_section_0_lesson_list_0_lession_title":["IAM dataset and table\/view access"],"_course_section_3_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_1_lession_title":["Column-level security"],"_course_section_3_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list_2_lession_title":["Row-level security"],"_course_section_3_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_3_section_0_lesson_list":["3"],"_course_section_3_section_0_lesson_list":["field_612f530a0ac40"],"course_section_3_section_1_title":["Objectives"],"_course_section_3_section_1_title":["field_612f5233b0278"],"course_section_3_section_1_lesson_list_0_lession_title":["Understand BigQuery security settings using Dataform."],"_course_section_3_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_3_section_1_lesson_list":["1"],"_course_section_3_section_1_lesson_list":["field_612f530a0ac40"],"course_section_3_section":["2"],"_course_section_3_section":["field_612f51e6b0277"],"course_section_4_module_title":["Assertions"],"_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":["Topics"],"_course_section_4_section_0_title":["field_612f5233b0278"],"course_section_4_section_0_lesson_list_0_lession_title":["Use built-in assertions."],"_course_section_4_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list_1_lession_title":["Create manual assertions."],"_course_section_4_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_4_section_0_lesson_list":["2"],"_course_section_4_section_0_lesson_list":["field_612f530a0ac40"],"course_section_4_section_1_title":["Objectives"],"_course_section_4_section_1_title":["field_612f5233b0278"],"course_section_4_section_1_lesson_list_0_lession_title":["Use assertions to validate data in Dataform workflows."],"_course_section_4_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_4_section_1_lesson_list":["1"],"_course_section_4_section_1_lesson_list":["field_612f530a0ac40"],"course_section_4_section_2_title":["Activities"],"_course_section_4_section_2_title":["field_612f5233b0278"],"course_section_4_section_2_lesson_list_0_lession_title":["1 lab "],"_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"],"course_section_5_module_title":["SQL Workflow Executions"],"_course_section_5_module_title":["field_612f5535940c3"],"course_section_5_module_description":[""],"_course_section_5_module_description":["field_612f564c921af"],"course_section_5_section_0_title":["Topics"],"_course_section_5_section_0_title":["field_612f5233b0278"],"course_section_5_section_0_lesson_list_0_lession_title":["Dataform code lifecycle"],"_course_section_5_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_1_lession_title":["What happens during compilation"],"_course_section_5_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_2_lession_title":["Customize and schedule compilation results"],"_course_section_5_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_3_lession_title":["Execute workflows (UI, Cloud Scheduler, Cloud Composer)"],"_course_section_5_section_0_lesson_list_3_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list_4_lession_title":["Logging and monitoring"],"_course_section_5_section_0_lesson_list_4_lession_title":["field_612f533b0ac41"],"course_section_5_section_0_lesson_list":["5"],"_course_section_5_section_0_lesson_list":["field_612f530a0ac40"],"course_section_5_section_1_title":["Objectives"],"_course_section_5_section_1_title":["field_612f5233b0278"],"course_section_5_section_1_lesson_list_0_lession_title":["Execute Dataform SQL workflows in an automated fashion."],"_course_section_5_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_1_lesson_list":["1"],"_course_section_5_section_1_lesson_list":["field_612f530a0ac40"],"course_section_5_section_2_title":["Activities"],"_course_section_5_section_2_title":["field_612f5233b0278"],"course_section_5_section_2_lesson_list_0_lession_title":["1 lab "],"_course_section_5_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_5_section_2_lesson_list":["1"],"_course_section_5_section_2_lesson_list":["field_612f530a0ac40"],"course_section_5_section":["3"],"_course_section_5_section":["field_612f51e6b0277"],"course_section_6_module_title":["Advanced Use Cases"],"_course_section_6_module_title":["field_612f5535940c3"],"course_section_6_module_description":[""],"_course_section_6_module_description":["field_612f564c921af"],"course_section_6_section_0_title":["Topics"],"_course_section_6_section_0_title":["field_612f5233b0278"],"course_section_6_section_0_lesson_list_0_lession_title":["Create a BigLake table after file upload using Cloud Run functions."],"_course_section_6_section_0_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_1_lession_title":["Build a Machine Learning pipeline with BigQuery ML."],"_course_section_6_section_0_lesson_list_1_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list_2_lession_title":["Work with Slowly Changing Dimensions Type 2."],"_course_section_6_section_0_lesson_list_2_lession_title":["field_612f533b0ac41"],"course_section_6_section_0_lesson_list":["3"],"_course_section_6_section_0_lesson_list":["field_612f530a0ac40"],"course_section_6_section_1_title":["Objectives"],"_course_section_6_section_1_title":["field_612f5233b0278"],"course_section_6_section_1_lesson_list_0_lession_title":["Explore additional use cases for Dataform."],"_course_section_6_section_1_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_1_lesson_list":["1"],"_course_section_6_section_1_lesson_list":["field_612f530a0ac40"],"course_section_6_section_2_title":["Activities"],"_course_section_6_section_2_title":["field_612f5233b0278"],"course_section_6_section_2_lesson_list_0_lession_title":["1 lab "],"_course_section_6_section_2_lesson_list_0_lession_title":["field_612f533b0ac41"],"course_section_6_section_2_lesson_list":["1"],"_course_section_6_section_2_lesson_list":["field_612f530a0ac40"],"course_section_6_section":["3"],"_course_section_6_section":["field_612f51e6b0277"],"sale_price_dates_start":[""],"sale_price_dates_end":[""],"_thumbnail_id":["13797"],"_yoast_wpseo_primary_stm_lms_course_taxonomy":["58"],"_yoast_wpseo_title":["Orchestrate BigQuery Workloads Easily with Dataform - CloudThat"],"_yoast_wpseo_metadesc":["Learn how to efficiently orchestrate BigQuery workloads using Dataform, simplifying complex data pipelines for better performance and management."],"after_completing_course_0_desciption":["Understand the components of Dataform core. "],"_after_completing_course_0_desciption":["field_6103ad2f9f5b2"],"after_completing_course_1_desciption":["Create tables and views in BigQuery using Dataform. "],"_after_completing_course_1_desciption":["field_6103ad2f9f5b2"],"after_completing_course_2_desciption":["Document BigQuery tables and views. "],"_after_completing_course_2_desciption":["field_6103ad2f9f5b2"],"after_completing_course_3_desciption":["Understand BigQuery security settings using Dataform. "],"_after_completing_course_3_desciption":["field_6103ad2f9f5b2"],"after_completing_course_4_desciption":["Use assertions to validate data in Dataform workflows. "],"_after_completing_course_4_desciption":["field_6103ad2f9f5b2"],"after_completing_course_5_desciption":["Execute Dataform SQL workflows in an automated fashion "],"_after_completing_course_5_desciption":["field_6103ad2f9f5b2"],"key_features_0_lists":["Dataform allows you to create repositories for managing your code."],"_key_features_0_lists":["field_6103ad559f5b3"],"key_features_1_lists":["Dataform enables you to create workspaces for development."],"_key_features_1_lists":["field_6103ad559f5b3"],"key_features_2_lists":["Dataform allows you to develop the Dataform core within a development workspace."],"_key_features_2_lists":["field_6103ad559f5b3"],"key_features_3_lists":["Dataform compiles the Dataform core."],"_key_features_3_lists":["field_6103ad559f5b3"],"key_features_4_lists":["Dataform runs the dependency tree."],"_key_features_4_lists":["field_6103ad559f5b3"],"who_should_attend_0_attend_lists":["Any data analyst, data engineer, or other data professional who wishes to use Dataform to orchestrate data workloads in BigQuery"],"_who_should_attend_0_attend_lists":["field_6103adfb3f3e4"],"course_features_0_features_list_0_list":["Create curated, up-to-date, reliable, and well-documented tables in BigQuery."],"_course_features_0_features_list_0_list":["field_644a0fc80e680"],"course_features_0_features_list_1_list":["Facilitate collaboration between data analysts and data engineers within the same repository."],"_course_features_0_features_list_1_list":["field_644a0fc80e680"],"course_features_0_features_list_2_list":["Create scalable data pipelines in BigQuery using SQL."],"_course_features_0_features_list_2_list":["field_644a0fc80e680"],"course_features_0_features_list_3_list":["Connect with GitHub and GitLab."],"_course_features_0_features_list_3_list":["field_644a0fc80e680"],"course_features_0_features_list_4_list":["Maintain updated tables without the need to manage infrastructure."],"_course_features_0_features_list_4_list":["field_644a0fc80e680"],"_regular_price_wmcp":["{\"USD\":\"399\",\"GBP\":\"349\",\"BDT\":\"25999\"}"]},"acf":[],"_links":{"self":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/22664"}],"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\/13"}],"version-history":[{"count":0,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm-courses\/22664\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media\/13797"}],"wp:attachment":[{"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/media?parent=22664"}],"wp:term":[{"taxonomy":"stm_lms_course_taxonomy","embeddable":true,"href":"https:\/\/www.cloudthat.com\/training\/wp-json\/wp\/v2\/stm_lms_course_taxonomy?post=22664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}