Installing and initializing a dbt project - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to install dbt using pip.

dbt

pip install [1]

Drag options to blanks, or click blank then click option'

Adbt

Bdbt-core

Cdbt-utils

Ddbt-run

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'dbt-core' instead of 'dbt' for installation.

Trying to install 'dbt-run' which is not a package.

Confusing utility packages like 'dbt-utils' with the main package.

To install dbt, you use pip install dbt. This installs the main dbt package.

2fill in blank

medium

Complete the command to initialize a new dbt project named 'my_project'.

dbt

dbt [1] my_project

Drag options to blanks, or click blank then click option'

Ainit

Bstart

Ccreate

Dnew

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'dbt start' which is not a valid command.

Using 'dbt create' or 'dbt new' which do not exist.

The command dbt init my_project creates a new dbt project folder named 'my_project'.

3fill in blank

hard

Fix the error in the command to run dbt models after initialization.

dbt

dbt [1]

Drag options to blanks, or click blank then click option'

Abuild

Bexecute

Crun

Dstart

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'dbt build' which is a different command.

Using 'dbt execute' which is not a valid command.

Using 'dbt start' which does not exist.

The correct command to run models is dbt run. Other options like 'build' or 'execute' are incorrect here.

4fill in blank

hard

Fill both blanks to create a new dbt model file named 'orders.sql' inside the models directory.

dbt

echo '[1]' > models/[2].sql

Drag options to blanks, or click blank then click option'

Aselect * from raw_orders

Borders

Ccustomers

Dselect * from raw_customers

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the model file name with the SQL query.

Using the wrong SQL query for the model.

The command writes the SQL query select * from raw_orders into a file named orders.sql inside the models folder.

5fill in blank

hard

Fill all three blanks to run dbt commands to install dependencies, compile, and then run models.

dbt

dbt [1] && dbt [2] && dbt [3]

Drag options to blanks, or click blank then click option'

Adeps

Bcompile

Crun

Dtest

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'test' instead of 'run' to execute models.

Skipping the 'deps' command before compiling.

Wrong order of commands.

This sequence installs dependencies (dbt deps), compiles the project (dbt compile), and runs the models (dbt run).