dbt Analytics Engineering Certification

By dbt Labs · Question Mode

QuestionQ27

Verified

You are building an incremental model.

Identify the circumstances under which is_incremental() evaluates to True or False.

Select
There is a config block at the top of the model with materialized = 'table'
The corresponding table already exists in the data warehouse
The incremental model was executed with the --full-refresh flag
The corresponding table does not already exist in the data warehouse
Explanation

is_incremental() is True only when the model is configured as incremental, the target already exists as a table, and a full refresh is not in effect. An existing table alone is not sufficient. Normally, --full-refresh makes the macro False, although an explicit full_refresh configuration can override the flag. (docs.getdbt.com)

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!