dbt_project.yml configuration - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the project name in dbt_project.yml.

dbt

name: [1]

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

Aversion

Bprofile

Cmy_dbt_project

Dmodels

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'version' or 'models' instead of the project name.

Leaving the name blank.

The name key in dbt_project.yml sets the project name.

2fill in blank

medium

Complete the code to specify the version of the dbt project.

dbt

version: [1]

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

A1.0

B'1.0'

Cone

Dv1

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the version number.

Using words instead of numbers.

The version should be a string, so it needs quotes.

3fill in blank

hard

Fix the error in the code to correctly define the profile name.

dbt

profile: [1]

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

Aprofile

Bdefault_profile

Cprofile_name

D'default_profile'

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the profile name unquoted.

Using an incorrect profile name.

The profile name must be a string, so it needs quotes.

4fill in blank

hard

Fill both blanks to define the models directory and the materialization strategy.

dbt

models:
  [1]:
    [2]: table

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

Amy_dbt_project

Bmaterialized

Cdefault

Dschema

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'schema' instead of 'materialized'.

Using 'default' instead of the project name.

The first blank is the project name under models. The second blank is the key for materialization strategy.

5fill in blank

hard

Fill all three blanks to configure the seeds directory, file format, and quoting.

dbt

seeds:
  [1]:
    [2]: csv
    [3]:
      identifier: true

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

Amy_dbt_project

Bfile_format

Cquote_columns

Dquoting

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up quote_columns and quoting.

Using wrong keys for file format.

The first blank is the project name under seeds. The second blank sets the file format. The third blank sets quoting options for identifiers.