Failure happened on 'destination' side. ErrorCode=DeltaInvalidCharacterInColumnName.

Question

This exception occurred when I use the pipeline of data factory to copy data from sql server to lakehouse. But I didn't find any problems with the raw data.

Answer 1

The error message "DeltaInvalidCharacterInColumnName" indicates that there is an invalid character in one of the column names in the Delta table. The error message suggests using an alias to rename the column. This error can occur when copying data from SQL Server to a lakehouse using Azure Data Factory. It is possible that the raw data in SQL Server does not contain any problems, but the issue arises during the data copy process.

To resolve this issue, you can try renaming the column using an alias. You can also check the schema of the Delta table to ensure that all column names are valid.

---

References:

• Error classes in Azure Databricks - Delta Lake
• Troubleshoot mapping data flows in Azure Data Factory (ADF) - Miscellaneous troubleshooting tips
• On-premises data gateway considerations for data destinations in Dataflow Gen2 - Network issues with port 1433

Answer 2

The problem is " " your column need "_" example "Name column" = Name_column