Used dbt to do CDC via SYSTEM_VERSIONING in MSSQL. Thought this was kinda cool so thought I'd share. Not so much to do with Meltano, unless we could get source tables auto populated in dbt
t
taylor
05/26/2021, 9:01 PM
oh interesting! is this within the same database that you’re reading that?
v
visch
05/27/2021, 1:33 AM
Yes same DB, Stage models -> versioned models, had to do a little customization on the incremental model to add a merge strategy but it does work!