Group-based ownership in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to assign ownership to a group in a dbt model.

dbt

version: 2
models:
  - name: sales_data
    [1]: ['data_team']

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

Agroups

Bowners

Ctags

Ddescription

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'owners' instead of 'groups' for group ownership.

Confusing 'tags' with ownership assignment.

The groups key is used to assign ownership to a group in dbt model configurations.

2fill in blank

medium

Complete the code to specify multiple groups owning a dbt model.

dbt

models:
  - name: customer_info
    groups: [[1]]

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

A'marketing'

B'analytics_team'

C'data_engineers'

D'analytics_team', 'data_engineers'

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around group names.

Listing groups without commas.

To assign multiple groups, list them as strings inside the brackets separated by commas.

3fill in blank

hard

Fix the error in the group ownership assignment in this dbt model YAML.

dbt

models:
  - name: orders
    groups: [1]

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

A'data_team'

Bdata_team

C['data_team']

Ddata_team[]

Attempts:

3 left

💡 Hint

Common Mistakes

Assigning a single string without list brackets.

Using invalid syntax like 'data_team[]'.

The groups key expects a list of strings, so the value must be a list like ['data_team'].

4fill in blank

hard

Fill both blanks to create a dbt model YAML with group ownership and a description.

dbt

models:
  - name: [1]
    groups: [[2]]
    description: 'Model owned by the data team.'

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

Asales_summary

Bdata_team

Cmarketing_team

Dcustomer_data

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up model names and group names.

Using group names that don't match the description.

The model name is 'sales_summary' and the group owning it is 'data_team'.

5fill in blank

hard

Fill all three blanks to define a dbt model YAML with multiple groups and a tag.

dbt

models:
  - name: [1]
    groups: [[2]]
    tags: [[3]]

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

Acustomer_orders

Bsales_team

Cpriority

Dfinance_team

Attempts:

3 left

💡 Hint

Common Mistakes

Not using lists for groups or tags.

Confusing tags with groups.

The model is 'customer_orders', owned by 'sales_team', and tagged as 'priority'.