How to Perform Insert only in DBT

Help
,
1

Hi,

I have a dbt table, and I want to do the Insertion of rows using dbt, what’s the best way to perform insert only in the table instead of recreating the whole table.

2

An incremental model. The dbt-bigquery adapter doesn’t have an append materialisation but you can use merge if you use a merge key that can’t ever match

Note: @Mike Stanley originally posted this reply in Slack. It might not have transferred perfectly.

3

can you explain in detail, like how to do?

4

you could also make your own append strategy

Note: @Mike Stanley originally posted this reply in Slack. It might not have transferred perfectly.

5

I’m pretty new to dbt, is there a doc which I can refer

6

For append only don’t use unique_key

{{
  config(
    materialized = 'incremental'
  )
}}

https://docs.getdbt.com/docs/build/incremental-strategy