This is a companion discussion topic for the original entry at Strategies for change data capture in dbt | dbt Developer Blog
This is something good for the SCD type the other way it supports to CDC as well but not core usage like unnecessary I am maintaining all data active inactive in CDC it’s straight requirement to have change data capture in source and target.
If I am using spark delta with dbt then it should supports like merge