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

Xavier Yan 0 Reputation points
2024-03-18T13:42:24.5+00:00

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.

User's image

User's image

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,408 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,990 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2024-03-18T13:42:24.5166667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    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:

    0 comments
  2. Monroy, Mauricio 0 Reputation points
    2024-06-26T22:18:42.0533333+00:00

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

    0 comments