Thanks for info and bit more insights into the issue @srikanthp24.

If it's not the issue with initial load but the incremental ingestion, is it just small volumes being ingested across in the 14 tables? Could you check the staging volume folders/query the volume/ event_log tables to see the metadata and number of records being pulled across from CDC?

On the pipelines details page doe it show anything like Snapshot/ Incremental? If it's incremental then should be fine after first full snapshot has been ingested.

Regarding the Connection Failure error, I agree that logs weren't conclusive enough to identify the root cause as the retry with exponential backoff is default mechanism of the pipeline on failures, but it could possibly be Network / congestion issue as you said while doing the ingestion. Also worth checking the connection happening in SQL server side to see how much time it runs and if any heavy load as well happening.