Model naming conventions in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to name a dbt model file correctly.

dbt

models/[1].sql

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

Acustomer-orders

BCustomerOrders

Ccustomer_orders

Dcustomer orders

Attempts:

3 left

💡 Hint

Common Mistakes

Using camel case or spaces in model file names.

Using hyphens instead of underscores.

dbt model files should use lowercase letters and underscores to separate words, like customer_orders.sql.

2fill in blank

medium

Complete the code to define a model name in dbt's dbt_project.yml file.

dbt

models:
  my_project:
    [1]:
      materialized: table

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

Acustomer_orders

BCustomerOrders

Ccustomer-orders

Dcustomer orders

Attempts:

3 left

💡 Hint

Common Mistakes

Using camel case or spaces in model names.

Using hyphens instead of underscores.

Model names in dbt_project.yml should use lowercase and underscores, matching the file names.

3fill in blank

hard

Fix the error in the model name to follow dbt naming conventions.

dbt

select * from [1]

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

Acustomer orders

BCustomerOrders

Ccustomer-orders

Dcustomer_orders

Attempts:

3 left

💡 Hint

Common Mistakes

Using uppercase letters in model names.

Using spaces or hyphens instead of underscores.

dbt model names should be lowercase with underscores, so customer_orders is correct.

4fill in blank

hard

Fill both blanks to create a dbt model file path and name following conventions.

dbt

models/[1]/[2].sql

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

Astaging

BStaging

Ccustomer_orders

DCustomerOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Using uppercase letters in folder or file names.

Using camel case instead of underscores.

Folder names like staging and model file names like customer_orders.sql should be lowercase with underscores.

5fill in blank

hard

Fill all three blanks to define a model name, description, and materialization in dbt_project.yml following conventions.

dbt

models:
  my_project:
    [1]:
      description: "[2]"
      materialized: [3]

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

Acustomer_orders

BCustomer orders data

Ctable

DCustomerOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Using uppercase or camel case for model names.

Using invalid materialization types.

The model name should be lowercase with underscores (customer_orders), description is a simple string, and materialization is usually table.