Running tests with dbt test - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to run all tests in a dbt project.

dbt

dbt [1]

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

Atest

Bseed

Ccompile

Drun

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'dbt run' instead of 'dbt test'.

Trying to use 'dbt compile' to run tests.

Use dbt test to run all tests defined in your dbt project.

2fill in blank

medium

Complete the code to run tests only for the 'models' directory.

dbt

dbt test --select [1]

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

Asources

Bsnapshots

Cmodels

Dseeds

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'sources' or 'snapshots' instead of 'models'.

Omitting the --select flag.

The --select models option runs tests only on models.

3fill in blank

hard

Fix the error in the command to run tests on a specific model named 'customers'.

dbt

dbt test --select [1]

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

Acustomers

Bmodels.customers

Cmodel.customers

Dmodels/customers

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'models.customers' or path formats like 'models/customers' which are invalid selectors.

Use the model name directly with --select to run tests on that model.

4fill in blank

hard

Fill both blanks to run tests on models in the 'finance' directory and limit output to errors only.

dbt

dbt test --select [1] --[2]

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

Afinance

Bquiet

Cverbose

Dmodels

Attempts:

3 left

💡 Hint

Common Mistakes

Using --verbose instead of --quiet.

Selecting 'models' instead of 'finance' for the directory.

Use --select finance to choose the finance models and --quiet to show only errors.

5fill in blank

hard

Fill all three blanks to run tests on the 'sales' model, show verbose output, and use the 'fail-fast' option.

dbt

dbt test --select [1] --[2] --[3]

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

Asales

Bdebug

Cfail-fast

Dquiet

Attempts:

3 left

💡 Hint

Common Mistakes

Using --quiet instead of --debug.

Omitting the --fail-fast option.

Use --select sales to test the sales model, --debug for detailed output, and --fail-fast to stop on first failure.