Materializations (view, table, incremental, ephemeral) in dbt - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a model as a view in dbt.

dbt

materialized: '[1]'

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

Aephemeral

Btable

Cincremental

Dview

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'table' instead of 'view' creates a physical table, not a view.

Using 'incremental' or 'ephemeral' changes how data is stored or processed.

Setting materialized: 'view' creates a view in the database.

2fill in blank

medium

Complete the code to define a model as an incremental table in dbt.

dbt

materialized: '[1]'

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

Aincremental

Bview

Ctable

Dephemeral

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'table' rebuilds the entire table every time.

Choosing 'view' does not store data physically.

Using materialized: 'incremental' allows dbt to add new data without rebuilding the whole table.

3fill in blank

hard

Fix the error in the materialization type to create a temporary model that does not create a table or view.

dbt

materialized: '[1]'

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

Aephemeral

Bview

Ctable

Dincremental

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'table' or 'view' creates physical objects in the database.

Using 'incremental' expects a table to update.

ephemeral models do not create tables or views but are compiled into SQL in downstream models.

4fill in blank

hard

Fill both blanks to create a model that materializes as a table and uses a unique key for incremental updates.

dbt

materialized: '[1]'
unique_key: '[2]'

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

Atable

Bview

Cid

Dincremental

Attempts:

3 left

💡 Hint

Common Mistakes

Setting materialized to 'table' but providing unique_key does not enable incremental behavior.

Using 'view' materialization ignores unique_key.

Incremental models need a unique_key to identify new or changed rows. The materialization must be 'incremental'.

5fill in blank

hard

Fill all three blanks to create an ephemeral model that selects from a source table and filters rows where status is 'active'.

dbt

with source_data as (
    select * from [1]
)

select * from source_data where [2] = '[3]'

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

Aref('source_table')

Bstatus

Cactive

Dref('another_table')

Attempts:

3 left

💡 Hint

Common Mistakes

Using a wrong table reference in the first blank.

Using a column name or value incorrectly in the filter.

Ephemeral models use ref() to refer to source tables. Filtering by status = 'active' selects only active rows.