cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks to Dataverse migration via ADF copy data

DivyaKumar
New Contributor

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

1 REPLY 1

-werners-
Esteemed Contributor III

That is not a valid guid.
Dataverse will check this.

http://guid.us/test/guid

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now