Installing packages with packages.yml in dbt - Practice Exercises

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the effect of this packages.yml content?

Given the following packages.yml file content, what will happen when you run dbt deps?

dbt

packages:
  - package: dbt-labs/dbt_utils
    version: 0.8.0
  - package: fishtown-analytics/codegen
    version: 0.3.0

A dbt will download and install dbt_utils version 0.8.0 and codegen version 0.3.0 packages into the project.

B dbt will update all installed packages to their latest versions ignoring the specified versions.

C dbt will remove all packages and not install anything because the versions are outdated.

D dbt will only install dbt_utils package and ignore codegen because only one package is supported.

💡 Hint

Think about what dbt deps does with the packages.yml file.

The packages.yml file lists packages and their versions. Running dbt deps downloads and installs these exact versions into your project.

❓ data_output

intermediate

How many packages will be installed?

Given this packages.yml content, how many packages will be installed after running dbt deps?

dbt

packages:
  - package: dbt-labs/dbt_utils
    version: 0.7.0
  - package: fishtown-analytics/codegen
    version: 0.3.0
  - package: dbt-labs/snowflake
    version: 0.2.0

A 3

B 2

C 1

D 0

💡 Hint

Count the number of package entries under packages:.

Each entry under packages: represents one package to install. Here, there are three entries, so three packages will be installed.

🔧 Debug

advanced

Identify the error in this packages.yml

What error will occur when running dbt deps with this packages.yml content?

dbt

packages:
  - package dbt-labs/dbt_utils
    version: 0.8.0

A Version conflict error because version is too low

B FileNotFoundError because packages.yml is missing

C No error, packages will install correctly

D SyntaxError due to missing colon after 'package'

💡 Hint

Check YAML syntax carefully for missing punctuation.

The YAML syntax requires a colon after keys. Missing colon after 'package' causes a syntax error.

🧠 Conceptual

advanced

Why specify package versions in packages.yml?

Why is it important to specify exact package versions in packages.yml instead of leaving versions out?

A To allow dbt to always install the newest package versions automatically

B To enable dbt to skip package installation if versions are missing

C To ensure consistent and repeatable builds by locking package versions

D To reduce the size of the packages installed by skipping dependencies

💡 Hint

Think about what happens if package versions change over time.

Specifying exact versions locks dependencies so your project builds the same way every time, avoiding unexpected changes.

🚀 Application

expert

Predict the installed package versions

Given this packages.yml content and that the latest available versions are dbt_utils 0.9.0 and codegen 0.4.0, what versions will be installed after dbt deps?

dbt

packages:
  - package: dbt-labs/dbt_utils
    version: 0.8.0
  - package: fishtown-analytics/codegen
    version: 0.3.0

A dbt_utils 0.8.0 and codegen 0.4.0

B dbt_utils 0.8.0 and codegen 0.3.0

C dbt_utils 0.9.0 and codegen 0.4.0

D dbt_utils 0.9.0 and codegen 0.3.0

💡 Hint

Remember how dbt uses the version specified in packages.yml.

dbt installs the exact versions listed in packages.yml, not the latest available versions.

Practice

1. What is the main purpose of the packages.yml file in a dbt project?

easy

A. To list external packages and their versions for installation

B. To define database connection settings

C. To write SQL models for transformations

D. To configure dbt user permissions

Solution

1. Step 1: Understand the role of packages.yml and compare with other dbt files

   This file is used to specify external packages that the dbt project depends on, including their names and versions. Database connections are set in profiles.yml, SQL models are separate files, and permissions are managed outside packages.yml.

2. Final Answer:

   To list external packages and their versions for installation -> Option A

3. Quick Check:

   packages.yml = package list [OK]

Hint: Remember: packages.yml lists packages, not configs or code [OK]

Common Mistakes:

• Confusing packages.yml with profiles.yml
• Thinking packages.yml contains SQL code
• Assuming it manages user permissions

2. Which of the following is the correct syntax to specify a package in packages.yml?

easy

A. - dbt_utils: 0.8.0

B. package: dbt_utils, version=0.8.0

C. dbt_utils: version 0.8.0

D. - package: dbt_utils
version: 0.8.0

Solution

1. Step 1: Recall YAML list syntax for packages and check each option format

   Packages are listed as items with a dash, followed by keys package and version indented below. - package: dbt_utils version: 0.8.0 matches the correct YAML format. Others use incorrect separators or structure.

2. Final Answer:

   - package: dbt_utils version: 0.8.0 -> Option D

3. Quick Check:

   YAML list with dash and keys = - package: dbt_utils version: 0.8.0 [OK]

Hint: YAML lists use dash and indentation for items [OK]

Common Mistakes:

• Using commas instead of new lines
• Missing dash for list items
• Incorrect key-value separators

3. Given this packages.yml content:

- package: dbt_utils
  version: 0.8.0
- package: fivetran_utils
  version: 0.3.0

What command should you run to install these packages?

medium

A. dbt deps

B. dbt install

C. dbt run

D. dbt build

Solution

1. Step 1: Identify the command for installing packages and differentiate from other dbt commands

   The command dbt deps reads packages.yml and installs or updates the listed packages. dbt install is not a valid command, dbt run runs models, and dbt build runs models and tests but does not install packages.

2. Final Answer:

   dbt deps -> Option A

3. Quick Check:

   Install packages = dbt deps [OK]

Hint: Use 'dbt deps' to install packages from packages.yml [OK]

Common Mistakes:

• Using 'dbt install' which doesn't exist
• Confusing 'dbt run' with package installation
• Trying 'dbt build' for package install

4. You added a new package to packages.yml but after running dbt deps, the package is not installed. What is the most likely reason?

medium

A. The package version is too new and unsupported

B. You ran dbt run instead of dbt deps

C. You forgot to save the packages.yml file before running the command

D. You need to restart your computer

Solution

1. Step 1: Check common user errors and evaluate other options

   If the packages.yml file was not saved, dbt deps reads the old file without the new package. Running dbt run does not install packages, but the question states dbt deps was run. Version issues usually cause errors, not silent skips. Restarting computer is unnecessary.

2. Final Answer:

   You forgot to save the packages.yml file before running the command -> Option C

3. Quick Check:

   Unsaved file = no package install [OK]

Hint: Always save packages.yml before running dbt deps [OK]

Common Mistakes:

• Assuming dbt run installs packages
• Ignoring file save before command
• Thinking restart fixes package install

5. You want to add the dbt_utils package version 0.8.0 and the fivetran_utils package version 0.3.0 to your project. Which packages.yml content is correct to install both packages properly?

hard

A. - dbt_utils: version 0.8.0
- fivetran_utils: version 0.3.0

B. - package: dbt_utils
version: 0.8.0
- package: fivetran_utils
version: 0.3.0

C. packages:
- dbt_utils: 0.8.0
- fivetran_utils: 0.3.0

D. - package: dbt_utils, version: 0.8.0
- package: fivetran_utils, version: 0.3.0

Solution

1. Step 1: Review correct YAML list format for multiple packages and check each option's correctness

   Each package is an item starting with a dash, followed by package and version keys on separate lines with indentation. - package: dbt_utils version: 0.8.0 - package: fivetran_utils version: 0.3.0 matches the correct YAML syntax. packages: - dbt_utils: 0.8.0 - fivetran_utils: 0.3.0 incorrectly adds a root key packages. - dbt_utils: version 0.8.0 - fivetran_utils: version 0.3.0 uses wrong key-value format. - package: dbt_utils, version: 0.8.0 - package: fivetran_utils, version: 0.3.0 uses commas inside YAML which is invalid.

2. Final Answer:

   - package: dbt_utils version: 0.8.0 - package: fivetran_utils version: 0.3.0 -> Option B

3. Quick Check:

   Proper YAML list with keys = - package: dbt_utils version: 0.8.0 - package: fivetran_utils version: 0.3.0 [OK]

Hint: List each package with dash, package, and version keys [OK]

Common Mistakes:

• Adding extra root keys like 'packages:'
• Using commas inside YAML list items
• Incorrect key-value formatting