Why you need to implement CDC from bronze to silver - that is strange.

Some time ago a kind person replied to me in a similar situation: 'Maybe you can more elaborate about your ground problem than asking about some solutian that you think is proper.' This is related to https://en.wikipedia.org/wiki/XY_problem

Do you need:

1. process your data from bronze to silver in the streaming manner (using Sructured Streaming)
2. process your data from bronze to silver using CDC (because in Bronze you have for example Delete operations on your data)
3. process tour data from bronze to silver using CDC in the streaming manner