insert+delete in incremental strategy

[unknownfakir1]

I am getting error while running insert+delete

insert+del query

error in compiled file

compiled query

[Surya]

u cannot write delete or insert statements in models. Your model should have only a select statement.

If you want to execute delete or insert statements we have to use About run_query macro | dbt Developer Hub or About statement blocks | dbt Developer Hub.

U have used delete and insert statements in ur model file, its not correct.