Why packages accelerate dbt development - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import a dbt package in your project.

dbt

packages:
  - package: [1]

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

Apandas

Bdbt_utils

Cnumpy

Dmatplotlib

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing packages unrelated to dbt like pandas or numpy.

Forgetting to add the package under the packages section.

The dbt_utils package is a common dbt package that provides useful macros to speed up development.

2fill in blank

medium

Complete the code to use a macro from a dbt package in a model.

dbt

select * from [1].get_relations_by_prefix('my_schema', 'my_prefix')

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

Amatplotlib

Bpandas

Cnumpy

Ddbt_utils

Attempts:

3 left

💡 Hint

Common Mistakes

Using Python package names instead of dbt package names.

Not referencing the package name before the macro.

The get_relations_by_prefix macro is part of the dbt_utils package, which helps with database tasks.

3fill in blank

hard

Fix the error in the dbt model code by completing the blank.

dbt

select
  [1]('column_name') as column_length
from my_table

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

Alength

Blen

Ccount

Dsum

Attempts:

3 left

💡 Hint

Common Mistakes

Using Python's len() instead of SQL's length().

Using aggregate functions like count or sum incorrectly.

In SQL, the function to get the length of a string is length, not len.

4fill in blank

hard

Fill both blanks to create a dictionary comprehension that filters words longer than 3 characters.

dbt

{word: [1] for word in words if len(word) [2] 3}

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

Alen(word)

B>

C<

Dword

Attempts:

3 left

💡 Hint

Common Mistakes

Using the word itself as the value instead of its length.

Using less than < instead of greater than >.

The dictionary comprehension uses len(word) as the value and filters words with length greater than 3 using >.

5fill in blank

hard

Fill all three blanks to create a dictionary comprehension that maps uppercase keys to values greater than zero.

dbt

result = [1]: [2] for k, v in data.items() if v [3] 0}

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

Ak.upper()

Bv

C>

Dk.lower()

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase keys instead of uppercase.

Using wrong comparison operators like < or ==.

The keys are converted to uppercase with k.upper(), values are v, and the filter keeps values greater than zero with >.

Practice

1. What is the main benefit of using packages in dbt development?

easy

A. They let you reuse tested dbt code easily.

B. They make dbt run slower.

C. They remove the need for SQL knowledge.

D. They replace the need for data testing.

Solution

1. Step 1: Understand what packages do in dbt

   Packages contain reusable dbt models and macros that are already tested.

2. Step 2: Identify the main benefit

   Using packages saves time and reduces errors by reusing tested code.

3. Final Answer:

   They let you reuse tested dbt code easily. -> Option A

4. Quick Check:

   Reusing tested code [OK]

Hint: Packages speed up development by reusing code [OK]

Common Mistakes:

• Thinking packages slow down dbt
• Believing packages remove SQL knowledge need
• Assuming packages replace testing

2. Which file do you add package dependencies to in a dbt project?

easy

A. models.yml

B. dbt_project.yml

C. profiles.yml

D. packages.yml

Solution

1. Step 1: Recall where dbt manages package dependencies

   dbt uses a special file named packages.yml to list external packages.

2. Step 2: Confirm the correct file

   Other files like dbt_project.yml configure the project but do not list packages.

3. Final Answer:

   packages.yml -> Option D

4. Quick Check:

   Package list file = packages.yml [OK]

Hint: Add packages in packages.yml file [OK]

Common Mistakes:

• Confusing packages.yml with dbt_project.yml
• Thinking profiles.yml manages packages
• Assuming models.yml lists packages

3. What command do you run after adding packages to packages.yml to install them?

medium

A. dbt deps

B. dbt install

C. dbt run

D. dbt build

Solution

1. Step 1: Identify the command to fetch packages

   After editing packages.yml, you must download packages using dbt deps.

2. Step 2: Differentiate from other commands

   dbt run runs models, dbt install is not a valid command, and dbt build runs build steps but does not fetch packages.

3. Final Answer:

   dbt deps -> Option A

4. Quick Check:

   Fetch packages command = dbt deps [OK]

Hint: Use dbt deps to install packages after editing packages.yml [OK]

Common Mistakes:

• Using dbt run instead of dbt deps
• Trying dbt install which does not exist
• Confusing dbt build with package installation

4. You added a package to packages.yml but forgot to run dbt deps. What will happen when you run dbt run?

medium

A. dbt will run successfully using the package code.

B. dbt will show an error about missing package dependencies.

C. dbt will ignore the package and run only local models.

D. dbt will automatically run dbt deps before running.

Solution

1. Step 1: Understand the role of dbt deps

   dbt deps downloads packages listed in packages.yml. Without running it, packages are not available locally.

2. Step 2: Predict behavior when running dbt run without deps

   Running dbt run without installed packages causes errors because dbt cannot find the package code.

3. Final Answer:

   dbt will show an error about missing package dependencies. -> Option B

4. Quick Check:

   Missing deps cause error [OK]

Hint: Always run dbt deps after changing packages.yml [OK]

Common Mistakes:

• Assuming dbt auto-runs deps
• Thinking dbt ignores missing packages
• Believing dbt run succeeds without deps

5. You want to speed up your dbt project by using a package that provides common date dimension models. What steps should you follow?

hard

A. Run dbt deps first, then add the package to packages.yml and run dbt run.

B. Copy the package code manually into your models folder and run dbt run.

C. Add the package to packages.yml, run dbt deps, then use the package models in your project.

D. Add the package to dbt_project.yml and run dbt build.

Solution

1. Step 1: Add package to packages.yml

   You must declare the package in packages.yml to tell dbt to use it.

2. Step 2: Run dbt deps to install the package

   This downloads the package code so dbt can use it.

3. Step 3: Use the package models in your project

   After installation, you can reference and use the package models in your own dbt models.

4. Final Answer:

   Add the package to packages.yml, run dbt deps, then use the package models in your project. -> Option C

5. Quick Check:

   Declare, install, use [OK]

Hint: Declare package, run dbt deps, then use models [OK]

Common Mistakes:

• Copying package code manually
• Running dbt deps before adding package
• Adding package to wrong config file