Forum Discussion

msprog's avatar
msprog
Icon for Advocate III rankAdvocate III
1 year ago
Solved

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

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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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 try 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 to -> Default_Create_Configuration_Code

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

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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 try 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 to -> Default_Create_Configuration_Code

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

 

Anonymous's avatar
Anonymous
Not applicable
11 months ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    11 months ago

    Hi msprog ,

    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      11 months ago

      Hi msprog ,
      I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions