Hi everyone,
is there anyway that I can exclude specific columns when I use materialisation = “incremental” and strategy= “merge” , I used the below Configs:
config(
materialized = ‘incremental’,
incremental_strategy = ‘merge’,
unique_key = ‘key’,
ignore_columns= [‘key’]
)
when its come to filter the inserted columns and not the updated column,
If there is a configuration like merge_update_columns, for inserted column “merge_insert_columns”
3 Likes
@asimalsaeed
as of now there is no such feature, but u can create a custom incremental strategy for your use case
plz refer this for custom incremental strategy incremental model (Merge) without update - #3 by Surya