Invalid incremental strategy provided: None

Help
1

Hello,
I’m a newbie to dbt pipeline development, I’ve created a pipeline but when I run “dbt run” I’m getting the below errors - any ideas what might be wrong please?

Unable to do partial parsing because env vars used in profiles.yml have changed
10:06:23 Found 1 model, 1 test, 0 snapshots, 0 analyses, 301 macros, 0 operations, 0 seed files, 4 sources, 0 exposures, 0 metrics
10:06:23
10:06:24 Concurrency: 1 threads (target=‘current’)
10:06:24
10:06:24 1 of 1 START sql incremental model dbt.coa_daily_1_0 … [RUN]
10:06:25 1 of 1 ERROR creating sql incremental model dbt.coa_daily_1_0 … [ERROR in 0.06s]
10:06:25
10:06:25 Finished running 1 incremental model in 0 hours 0 minutes and 1.67 seconds (1.67s).
10:06:25
10:06:25 Completed with 1 error and 0 warnings:
10:06:25
10:06:25 Compilation Error in model coa_daily_1_0 (models/raw/coa_daily_1_0.sql)
10:06:25 Invalid incremental strategy provided: None
10:06:25 Expected one of: ‘append’, ‘delete+insert’, ‘merge’
10:06:25
10:06:25 > in macro validate_get_incremental_strategy (macros/materializations/incremental.sql)
10:06:25 > called by macro materialization_incremental_trino (macros/materializations/incremental.sql)
10:06:25 > called by model coa_daily_1_0 (models/raw/coa_daily_1_0.sql)
10:06:25
10:06:25 Done. PASS=0 WARN=0 ERROR=1 SKIP=0 TOTAL=1

2

Do you have any config block in your coa_daily_1_0 model? If so can you share it?

It looks like you have not got an incremental strategy set, however the documentation says that the default is append in that case, so I wonder if you’ve set something strangely.