As per topic, is it possible to roll your own incremental_strategy? For example if the unique_key already exists, do nothing so that the original record is kept as is.

Yes, it’s possible to make your own strategy, check out Creating new materializations | dbt Developer Hub for an introduction. Before you go down that path, there’s another option which I haven’t tried but feels like it has decent odds of working: There are strategy-specific configs available when…

thanks for the reply @joellabes . I did arrive at the same thinking with merge_update_columns after reading other discussions here. unfortunately we are using postgres, which does not support merge strategy. I will have a read on Creating new materializations

If you get it working, I’d love to read about it in #show-and-tell ! Feel free to open another topic if you run into any implementation issues along the way

Is it possible to customize incremental_strategy?

Help

doug.beatty January 10, 2024, 10:27pm 7

@mwbong dbt now makes it easier to define custom incremental strategies in your project and you can also use those published within a package.

Topic		Replies	Views
Incremental_strategy = 'merge' Help incremental , postgres , dbt-core	3	837	August 19, 2024
incremental model (Merge) without update Help incremental	7	10407	April 27, 2023
incremental merge based on ID Help incremental , snowflake	1	459	August 10, 2024
merge_insert_columns Help incremental	3	2805	September 12, 2023
custom Incremental strategies Help incremental , best-practice , macros , dbt-core	2	2242	March 15, 2024

Is it possible to customize incremental_strategy?

Related topics