Change Data Capture in Azure Data factory High level resources does not ask for DelimitedText value, instead it takes comma(,) by default

Krishnamohan Nadimpalli 401

I am trying to implement CDC High Level Resources through Blob to SQL DB. But my mapping was incorrect as my source is delimited by "|", due to which I am unable to implement. Can we look into this? on how to change default comma(,) to Pipe(|)

[https://learn.microsoft.com/en-us/azure/data-factory/how-to-change-data-capture-resource

AnnuKumari-MSFT 31,146 Reputation points Microsoft Employee

2023-01-27T13:54:26.95+00:00

Hi Krishnamohan Nadimpalli ,

Thankyou for using Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you are trying to use change data capture feature within ADF and facing an issue while mapping.

Apologies to say that the image you posted is not visible. Could you please repost it so that we can help you better. Thankyou.
Krishnamohan Nadimpalli 401 Reputation points

2023-01-28T13:14:38.62+00:00

Hi @AnnuKumari-MSFT Thanks for taking up this.

When I create a CDC Resource in ADF, and when I select DelimitedText as my source. It takes comma as default delimited but my source is Pipe Delimited("|").
AnnuKumari-MSFT 31,146 Reputation points Microsoft Employee

2023-01-31T16:00:42.8633333+00:00

Hi @MarkKromer-MSFT ,

Tagging to see if we can get any input here? Thanks in advance.
MarkKromer-MSFT 5,186 Reputation points Microsoft Employee

2023-01-31T16:19:37.0633333+00:00

Looking into it ...
AnnuKumari-MSFT 31,146 Reputation points Microsoft Employee

2023-02-10T04:26:47.1066667+00:00

Hi MarkKromer-MSFT ,

Just checking if we can get any inputs here , CDC doesn't allow modifying the column delimiter in the dataset. Is the feature going to be added or we need to consider using only comma seperated data to leverage CDC feature? Thanks in advance for your time .