Column descriptions in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

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

dbt

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

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

ANumber of items purchased

BThe total sales amount

CDate of the transaction

DUnique identifier for each customer

Attempts:

3 left

💡 Hint

Common Mistakes

Using a description that does not match the column name

Leaving the description empty

The description field should explain what the column customer_id represents. Here, it is the unique identifier for each customer.

2fill in blank

medium

Complete the code to add a description for the order_date column in a dbt model.

dbt

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

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

ANumber of products in the order

BDate when the order was placed

CTotal price of the order

DCustomer's unique ID

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing order_date with customer ID or price

Writing a vague description

The order_date column stores the date when the order was placed, so the description should reflect that.

3fill in blank

hard

Fix the error in the column description for total_amount by selecting the correct description.

dbt

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

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

ATotal amount of the order in USD

BDate of the transaction

CUnique customer identifier

DNumber of items sold

Attempts:

3 left

💡 Hint

Common Mistakes

Using descriptions related to date or customer ID

Not specifying the currency or total nature

The total_amount column should describe the total value of the order, usually in a currency like USD.

4fill in blank

hard

Fill both blanks to add descriptions for product_id and quantity columns in a dbt model.

dbt

columns:
  - name: product_id
    description: "[1]"
  - name: quantity
    description: "[2]"

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

AUnique identifier for each product

BNumber of units ordered

CDate when the product was added

DPrice per unit of the product

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up descriptions between product and quantity

Using unrelated descriptions

product_id is the unique ID for products, and quantity is the number of units ordered.

5fill in blank

hard

Fill all three blanks to add descriptions for user_id, signup_date, and is_active columns in a dbt model.

dbt

columns:
  - name: user_id
    description: "[1]"
  - name: signup_date
    description: "[2]"
  - name: is_active
    description: "[3]"

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

AUnique identifier for each user

BDate when the user signed up

CIndicates if the user account is active

DTotal number of user logins

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing is_active with login counts

Using vague or incorrect descriptions

user_id is the unique user ID, signup_date is when the user joined, and is_active shows if the account is currently active.