I don’t want the older data to be deleted or updated. rather I just want to insert data everyday
1 Like
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
2 Likes
Yes. If you do not specify unique_key
it will not attempt to update or delete anything.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.