Mastering Google Dataform: From Beginner to Pro- BigQuery

سرفصل های دوره

Your Complete Guide to Data Transformation Mastery- Dataform-BigQuery

1. Introduction

1. Lets get started

2. Introduction

3. What is Google DataForm

4. Google Dataform vs. DBT Core vs. DBT Cloud

2. Dataform setup

1. Create GCP project

2.1 Useful Resources .pdf

2. Create Github Repository

3. Create Github Token

4. Setup your repository in Dataform

5. Link Github with Dataform

6.1 Dataform CLI Commands - Summary.pdf

6. Dataform Initialization

7.1 Useful Resources .pdf

7. Test connection between Google Dataform and Github

3. Setup DataForm Locally (CLI) and service accounts to access BigQuery

1. Overview

2. Creating Service Account

3. Creating First Dataform Model in GCP

4.1 Dataform CLI Commands - Summary.pdf

4. Setting up local environment - CLI

5. Running DataForm Locally and in GCP

4. Working with DataForm

1. Overview

2.1 Create data sample in BQ.pdf

2. Add Sample data to BigQuery

3. Create data Sources in Dataform and Manage Dependencies

4. Create Views in BigQuery using DataFrom (GCP & CLI)

5. Explore BigQuery

6. Create Materialized Views in BigQuery using DataFrom

5. Incremental Models in Dataform

1. Incremental models explained

2. Implementing Incremental models in Dataform - Part 1

3. Implementing Incremental models in Dataform - Part 2

6. Slowly Changing Dimensions (SCD) using Google Dataform

1.1 Slowly changing dimension(SCD) - code template.pdf

1.2 Useful Resources .pdf

1. Slowly Changing Dimensions (SCD) Explained

2.1 Config files .pdf

2.2 Dataform CLI Commands - Summary.pdf

2.3 Slowly changing dimension(SCD) - code template.pdf

2.4 Useful Resources .pdf

2. Implementing SCD using Dataform

7. Assertions using Google Dataform - Data Quality Checks

1. Adding Assertions to Dataform models

2.1 Useful Resources .pdf

2. Working with custom assertions in Dataform

8. Explore and work with Dataform Workflow in GCP

1. Tags in Dataform

2. Sync local changes with remote GitHub and Datafrom

3. Dataform Graph

4. Schedule a Workflow in DataForm

9. Thank you

1. Thank you for attending this course

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy