Hi team,
I need to load data from databricks delta tables to dataverse tables and I have one unique id column which I am ensuring via mapping. Its datatype is GUID in dataverse and string in delta table. I ensured that column holds unique values. Since this data type conversion is not happening via single copy data activity with source as databricks and sink as dataverse, I split the copy data into 2 - one from databricks to ADLS and other from ADLS to dataverse. databricks to ADLS worked fine. second copy data is done with upsert logic and mapping also done, but it throws error as below:
"ErrorCode=TypeConversionFailure,Exception occurred when converting value '7c820e84-Oce8-4ce6-aeOa-f25501c3399e' for column name 'xxx' from type 'String' (precision:-1, scale:-1) to type 'Guid' (precision:, scale:). Additional info: Could not find any recognizable digits."
please help how to solve