type

project_id

private_key_id

client_email

client_id

auth_uri

token_uri

auth_provider_x509_cert_url

client_x509_cert_url

private_key

project_name

dataset_name

dataset_location

dataproc_cluster_name

gcs_bucket

dataproc_region

dev_dataset_name

Gain insights into setting up dbt, managing models, and leveraging features like data testing. Delve into efficient data pipelines and improve data workflows in this data build tools course.

dbt.tqr.gz

Gcloud authentification

Welcome

Move to usercode

Coding challenge 1

Run shop project

Coding challenge 2-copy

Environment variables

Packages

Dbt tests

Dbt init

Dbt debug & run

Dbt run test_project

Dbt  compile

Dbt run select

dbt snapshot

Dbt  compile analyses

Dbt  docs

Finale coding challenge

dbt Seed

dbt versions

Run both targets

This course offers a comprehensive introduction to data build tools (dbt), a powerful data transformation tool that streamlines the development and management of data pipelines. You will learn to set up and configure dbt projects, create and manage models, work with data sources, and leverage advanced features like data testing, targets, and snapshots.

The course covers various topics, from the basics of dbt to more advanced concepts. You will gain hands-on experience through coding challenges and quizzes, reinforcing your understanding of the material. By the end of the course, you will be well-equipped to build efficient and maintainable data pipelines using dbt.

Whether you are a data engineer, analyst, or data scientist, this course will equip you with the skills and knowledge to leverage dbt to its full potential. You will learn to improve data quality, automate data workflows, and collaborate effectively within your team.

Learn Data Build Tools ( DBT )

```<sql>
{{ set bob_asleep=False }}
{{ if bob_asleep }}
Shhh, don't make noise! Bob is asleep.
{{ else }}
Bob is awake! Play with him.
{{ endif }}
```

```<sql>
{%- set bob_asleep=False %}
{%- if bob_asleep %}
Shhh, don't make noise! Bob is asleep.
{% else -%}
Bob is awake! Play with him.
```

```<sql>
{%- set bob_asleep=False %}
{%- if bob_asleep %}
Shhh, don't make noise! Bob is asleep.
{% else -%}
Bob is awake! Play with him.
{% endif %}
```

```<sql>
{%- set bob_asleep=True %}
{%- if bob_asleep %}
Shhh, don't make noise! Bob is asleep.
{% else -%}
Bob is awake! Play with him.
{% endif %}
```

Which template compiles as follows?
```<txt>
Bob is awake! Play with him.
```

Which template compiles as follows?
<pre><code class="language-&lt;txt&gt;">Bob is awake! Play with him.
</code></pre>

```
dbt run --vars '{"project_id":3}'
```

**(Select all that apply.)** Which command will run all models while passing the value `3` to the variable `project_id`? 

(Select all that apply.) Which command will run all models while passing the value <code>3</code> to the variable <code>project_id</code>?

Which is the best way to store a secret token?

Which is the best way to store a secret token?

```
{% declare color %}
{% color= "red" %}
```

**(Select all that apply.)** Which template creates a variable called `color` and assigns it the value `"red"`?

(Select all that apply.) Which template creates a variable called <code>color</code> and assigns it the value <code>&quot;red&quot;</code>?

```
{% set winners=["Ana", "Paulina", "Mike"]-%}
{% for winner in winners -%}
{{loop.index0}}.{{winner}}
{% endfor %}
```

```
{% set winners=["Ana", "Paulina", "Mike"]%}
{% for i,winner in enumerate(winners) -%}
{{i}}.{{winner}}
{% endfor %}
```

```
{% set winners=["Ana", "Paulina", "Mike"]%}
Podium:
{% for winner in winners %}
{{loop.index}}.{{winner}}
{% endfor %}
```

```
{% set winners=["Ana", "Paulina", "Mike"]-%}
Podium:
{% for winner in winners -%}
{{loop.index}}.{{winner}}
{% endfor %}
```

Which template compiles as follows?
```
Podium:
1.Ana
2.Paulina
3.Mike
```

Which template compiles as follows?
<pre><code>Podium:
1.Ana
2.Paulina
3.Mike
</code></pre>

Introduction to dbt and Its Setup

Overview of the Project Architecture

Models

Sources

Materializations

Dynamic Models with Jinja

Packages

Advanced dbt Concepts

Conclusion

Quiz: Jinja