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?
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? Read More
