@Pat thanks for your input! In my use case, I want to apply "create_auto_cdc_flow" on my last table. If I change my last table to be materialized view, I will get an unsupported destination error: 

java.lang.IllegalArgumentException: Unsupported destination cdc_notes_silver in flow: 
cdc_notes_silver_merge at transformerWithDestination

Do you have any suggestion on how to solve this issue?