Why documentation makes data discoverable in dbt - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add a description to a model in dbt.

dbt

models:
  - name: customers
    description: "[1]"

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

ACreate a table

BLoad data

CRun the model

DList of customers with details

Attempts:

3 left

💡 Hint

Common Mistakes

Using commands instead of descriptions

Leaving the description empty

Adding a description helps others understand what the model contains.

2fill in blank

medium

Complete the code to document a column in a dbt model.

dbt

columns:
  - name: customer_id
    description: "[1]"

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

AUnique identifier for each customer

BCustomer's age

CDate of purchase

DTotal sales amount

Attempts:

3 left

💡 Hint

Common Mistakes

Using unrelated descriptions

Leaving descriptions vague

Documenting columns with clear descriptions helps users find and understand data fields.

3fill in blank

hard

Fix the error in the dbt schema file to make documentation discoverable.

dbt

version: 2
models:
  - name: orders
    description: "Order details"
    columns:
      - name: order_id
        [1]: "Unique order number"

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

Adoc

Bdesc

Cdescription

Ddetails

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect keys like 'desc' or 'doc'

Misspelling 'description'

The correct key to document columns in dbt schema files is description.

4fill in blank

hard

Fill both blanks to create a documented test for a column in dbt.

dbt

tests:
  - [1]:
      severity: [2]

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

Anot_null

Bwarn

Cerror

Dunique

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'unique' test when checking for nulls

Setting severity to an invalid value

Using not_null test with warn severity helps catch missing data without failing the run.

5fill in blank

hard

Fill all three blanks to create a documented source in dbt.

dbt

sources:
  - name: [1]
    description: "[2]"
    tables:
      - name: [3]

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

Araw_data

BRaw data from sales system

Ctransactions

Dcustomers

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing source and table names

Leaving description empty

Documenting sources with clear names and descriptions helps users find original data tables.