MicrosoftThe CDC preview top level functionality is not really compatible with CI/CD workflow, where you have multiple datafactories. Say one for development (connected to git) and another for production (that is updated from say Azure Devops based on the git-repo ARM-scripts).
If you want to move the CDC Preview from dev to prod, you may lose data while the process is down during the deploy to production datafactory. Is there a plan to make the CDC (preview) top level feature work with CD/CD processes with multiple datafactories? Maybe a way to transfer the cdc-watermark between datafactories etc. or something like that. Not having the preview in the name would also be nice.
Is it possible to real-time headless Azure SQL (CDC-using) sourced data update from Pipelines(dataflow in them) instead of using the CDC (preview) top level feature?
