Why sources define raw data contracts in dbt - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a source in dbt.

dbt

sources:
  - name: [1]
    tables:
      - name: raw_users

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

Asource_data

Braw_data

Craw

Dusers

Attempts:

3 left

💡 Hint

Common Mistakes

Using table names instead of source names.

Using overly long or unclear source names.

The source name should be a simple identifier like raw to represent raw data sources.

2fill in blank

medium

Complete the code to add a freshness test to a source in dbt.

dbt

sources:
  - name: raw
    tables:
      - name: raw_users
        freshness:
          [1]: 24 hours

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

Awarn_after

Binterval

Cerror_after

Dmax_age

Attempts:

3 left

💡 Hint

Common Mistakes

Using interval which is not a valid freshness key.

Confusing error_after with warn_after.

The warn_after key sets the freshness threshold to warn if data is older than 24 hours.

3fill in blank

hard

Fix the error in the source definition by completing the missing key.

dbt

sources:
  - name: raw
    [1]: my_database
    tables:
      - name: raw_users

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

Adatabase

Blocation

Cschema

Dpath

Attempts:

3 left

💡 Hint

Common Mistakes

Using schema instead of database.

Using keys that do not exist in dbt source definitions.

The database key specifies the database where the source table lives.

4fill in blank

hard

Fill both blanks to define a source with a freshness test and a description.

dbt

sources:
  - name: raw
    database: analytics_db
    tables:
      - name: raw_orders
        description: [1]
        freshness:
          warn_after: [2]

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

A"Raw orders data from transactional system"

B24 hours

C7 days

D"Orders data from last month"

Attempts:

3 left

💡 Hint

Common Mistakes

Using a freshness interval that is too long for the data.

Leaving the description empty or unclear.

The description explains the source table, and warn_after sets freshness to 24 hours.

5fill in blank

hard

Fill all three blanks to create a source with database, schema, and freshness error threshold.

dbt

sources:
  - name: raw
    database: [1]
    schema: [2]
    tables:
      - name: raw_events
        freshness:
          error_after: [3]

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

Aanalytics_db

Braw_schema

C48 hours

Devents_db

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up database and schema names.

Using freshness values without units.

The database is analytics_db, schema is raw_schema, and freshness error threshold is 48 hours.