Seeds for static reference data in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a seed file in dbt.

dbt

version: 2
[1]:
  countries:
    path: data/countries.csv

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

Asnapshots

Btests

Cseeds

Dmodels

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'models' instead of 'seeds' in the schema file.

Confusing seeds with snapshots or tests.

The seeds key is used to define seed files in dbt's schema.yml.

2fill in blank

medium

Complete the code to load a seed file in dbt.

dbt

dbt [1] --select countries

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

Arun

Bseed

Ctest

Dsnapshot

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'dbt run' instead of 'dbt seed'.

Using 'dbt test' which runs tests, not seeds.

The dbt seed command loads CSV files defined as seeds into the data warehouse.

3fill in blank

hard

Fix the error in the seed configuration to disable header loading.

dbt

seeds:
  my_project:
    countries:
      [1]: false

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

Aheader

Bheaders

Cinclude_header

Dhas_header

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'headers' instead of 'header'.

Using keys like 'has_header' or 'include_header' which are invalid.

The correct config key to disable header loading in dbt seeds is header.

4fill in blank

hard

Fill all three blanks to create a dictionary comprehension filtering countries with names longer than 5 letters.

dbt

filtered = {country: data[country] [1] [2] len(country) [3] 5}

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

Afor country in data

B>

C<

Dif

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for filtering longer names.

Omitting 'for' or 'if' keywords.

The dictionary comprehension syntax is: {key: value for key in iterable if condition}.

5fill in blank

hard

Fill all three blanks to create a seed config that sets file path, header usage, and delimiter.

dbt

seeds:
  my_project:
    countries:
      [1]: data/countries.csv
      [2]: true
      [3]: ','

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

Apath

Bheader

Cdelimiter

Dformat

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'format' instead of 'delimiter'.

Confusing 'header' with 'headers'.

Seed config keys include path for file location, header to specify if the first row is header, and delimiter for the CSV separator.