Copy Data failure to lakehouse: sql server column names with spaces

[msprog]

we have an onprem sql server, In Fabric, a gateway connection is configured to the server. 

Now I have a pipeline with a Copy Data configured with source as this sql server and target  as the fabric lakehouse. 

Some of the sql tables have space in the column names and the Copy Data fails saying 

Failure happened on 'destination' side. ErrorCode=DeltaInvalidCharacterInColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column name Default Create Configuration Code contains invalid characters. ",;{}()\n\t=" are not supported.,Source=Microsoft.DataTransfer.ClientLibrary,'

anyone faced this issue before please suggest

thanks

[v-sshirivolu]

Hi @msprog ,
Thank you for reaching out to the Forum community.

This error occurs because Fabric Lakehouse (Delta tables) does not permit spaces or special characters in column names.

To fix it :

In the Copy Data activity, navigate to the Mapping tab. Map the source columns to target columns using valid names (replace spaces with underscores or remove special characters).
Example: Default Create Configuration Code -> Default_Create_Configuration_Code

Alternatively, you can use a SQL query or view to rename the columns before copying.

Regards,
Sreeteja.

[v-sshirivolu]

Hi @msprog ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[lbendlin]

That is a well known limitation. Remove the spaces from the table names and column names.