Forum Discussion
David Spriggs
May 21, 2024Copper Contributor
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