SCD-TYPE-1/SCD-TYPE-2 /CDC Integration in DBT

purwarapar · January 7, 2023, 2:22pm

Can we have CDC in DBT ?

jeffsk · January 8, 2023, 1:47pm

Hi, welcome to the forum.

I think this covers what you need for type 2:

Type 1 is a regular table.

Topic		Replies	Views
SCD type 2 in using dbt Archive	2	4009	March 23, 2021
Can I implement SCD2 in dbt without using snapshots? Help snapshots	6	6862	August 16, 2021
how to meet the requirement for the traditional design pattern for scd type 2 dimensional tables in the mart layer using dbt Help snapshots , incremental	2	772	July 28, 2023
Snapshotting from an existing SCD Type 2 table Archive	0	2333	April 5, 2022
can i create an scd type 2 model in dbt without using snapshot? Help	4	1212	March 1, 2023