@Retired_mod Thanks for the explanations! What I am not sure about is the following. I create streaming table within the apply changes syntax. However I need to have a table already with the data. Does this mean that in the apply changes, create streaming table syntax is just refrencing existing table as delta live table or? Further, do we always load the whole cdc table? Sorry if my questions are not good but I am trying to figure this out. Also just to confirm my understanding these keys are not from the cdc table but rather from the table we wish to apply changes to because we need to connect two records together.