Doc blocks for reusable descriptions in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a doc block named 'customer_desc'.

dbt

docs:
  [1]:
    description: "Description for customer table."

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

Acustomer_doc

Bdesc_customer

Ccustomer_description

Dcustomer_desc

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces or special characters in the doc block name.

Using a name that does not match the reference later.

The doc block name is defined under docs: with the key customer_desc.

2fill in blank

medium

Complete the code to reference the doc block 'customer_desc' in a model's description.

dbt

models:
  customer:
    description: '{{{{ doc([1]) }}}}'

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

A"customer_desc"

Bcustomer_desc

C'customer_desc'

D"customer_doc"

Attempts:

3 left

💡 Hint

Common Mistakes

Adding quotes inside the doc() function.

Using a different doc block name than defined.

When referencing a doc block in dbt, use doc(name) without quotes around the name inside the parentheses.

3fill in blank

hard

Fix the error in the doc block definition by completing the missing key.

dbt

docs:
  customer_desc:
    [1]: "Description for customer table."

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

Adescription

Bdesc

Cdoc

Ddetails

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect keys like 'desc' or 'doc'.

Misspelling 'description'.

The correct key for doc block text is description.

4fill in blank

hard

Fill both blanks to create a reusable doc block and reference it in a model.

dbt

docs:
  [1]:
    description: "Reusable description for orders."

models:
  orders:
    description: '{{{{ doc([2]) }}}}'

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

Aorders_desc

Border_description

Dorders_doc

Attempts:

3 left

💡 Hint

Common Mistakes

Using different names for the doc block and reference.

Misspelling the doc block name.

The doc block is named orders_desc and referenced by the same name in the model description.

5fill in blank

hard

Fill all three blanks to define two doc blocks and reference one in a model.

dbt

docs:
  [1]:
    description: "Description for customers."
  [2]:
    description: "Description for products."

models:
  products:
    description: '{{{{ doc([3]) }}}}'

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

Acustomer_desc

Bproduct_desc

Dcustomer_description

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up doc block names.

Referencing a doc block not defined.

The two doc blocks are customer_desc and product_desc. The model references product_desc.