Installing and initializing a dbt project - Quick Revision & Summary

Recall & Review

beginner

What is dbt and why do we use it?

dbt stands for data build tool. It helps transform raw data into clean, organized data models using simple SQL. We use it to make data analysis easier and more reliable.

beginner

What command installs dbt using pip?

You install dbt by running pip install dbt-core or for specific adapters like Postgres, pip install dbt-postgres.

beginner

What does the command dbt init my_project do?

It creates a new folder called my_project with all the files and folders needed to start a dbt project.

intermediate

Why do you need to configure the profiles.yml file in dbt?

The profiles.yml file tells dbt how to connect to your database by providing details like username, password, host, and database name.

beginner

What is the purpose of the models folder in a dbt project?

The models folder holds SQL files where you write your data transformation logic. dbt runs these to build tables or views in your database.

Which command initializes a new dbt project?

A dbt start project

B dbt init my_project

C dbt create project

D dbt new

The correct command to start a new dbt project is dbt init my_project.

What file must you edit to connect dbt to your database?

A profiles.yml

B dbt_project.yml

C connection.sql

D settings.json

The profiles.yml file contains database connection details for dbt.

Which Python package installs the core dbt functionality?

A dbt-sql

B dbt-utils

C dbt-core

D dbt-runner

The package dbt-core installs the main dbt tool.

Where do you write SQL models in a dbt project?

A scripts folder

B data folder

C sql folder

D models folder

SQL models are placed inside the models folder.

What does dbt primarily help you do?

A Build and run data transformations

B Store raw data

C Visualize data

D Create dashboards

dbt helps build and run data transformations using SQL.

Explain the steps to install and initialize a new dbt project from scratch.

Think about commands and configuration files needed.

Describe the role of the profiles.yml file in a dbt project.

It is about connecting dbt to your data source.