Forum Discussion

David Spriggs's avatar
David Spriggs
Copper Contributor
May 21, 2024

ADF Change Data Capture

I have been working on a proof of concept using the Azure Data Factory Change Data Capture, resource to move data from Azure SQL Database to Delta Lake target. The issue I am encountering is when the Azure Data Factory Change Data Capture source attempts to parse the schema it is returning an error:

"Failed to import schema for Source Table ...." and "com.microsoft.dataflow.broker.MissingRequiredPropertyException: server is a required property for ...." (names of resources are intentionally left out)

 

The Azure Data Factory MSI has access to read the schema and is a user in the Azure SQL Database. 

Thoughts?

No RepliesBe the first to reply

Resources