8. Found more columns than expected | Common Errors in ADF
In this video we learnt how to mitigate "Error found when processing 'Csv/Tsv Format Text’ .Found more columns than expected"
While using copy activity in Azure Data Factory to load data from CSV to SQL Table, the value would be considered as if they belong to 2 different columns if they have dataset delimiter within the value.
We need to consider using correct Quote character in dataset configuration
#adf #azuredataengineer #datafactory