Can we implement insert only with DBT incremental load

Help
1

I don’t want the older data to be deleted or updated. rather I just want to insert data everyday

2

Hello @sheetal.goyal ,

Based on the database ,we can achieve the APPEND only mode. Below is the case for big query database.

{{
    config(
        materialized='incremental'
    )
}}
select *
...

if we are not defining unique_key in config will result in append-only behavior

More Information @ : Incremental models | dbt Developer Hub

Regards
mp

3

Yes. If you do not specify unique_key it will not attempt to update or delete anything.