creation of tables with cdc

alexgv12 — Tue, 01 Nov 2022 14:35:47 GMT

I am using cdc to create different tables, these tables can have one or more dependencies, what is the best practice to create these tables without losing records or changes in both the base table and the join tables?

for example

select * from

(

SELECT *, rank() over (partition by cola order by _commit_version desc) as rank

FROM table_changes('database.table', 3)

WHERE _change_type !='update_preimage'

) a

WHERE a.rank=1

) as b

inner join

database.table2 as a

on a.cola = b.cola

my fear is that if a change does not occur in table but in table2 it is possible that I will lose the changes in table2.

Re: creation of tables with cdc

alexgv12 — Wed, 28 Dec 2022 15:00:20 GMT

more detail

topic creation of tables with cdc in Data Engineering

creation of tables with cdc

Re: creation of tables with cdc